Hi,
I have a table that looks like this
SortID | ID | Name | City |
1 | 1 | xxx | NYC |
2 | 1 | xxx | Seattle |
3 | 2 | yyy | DC |
4 | 3 | zzz | Pittsburgh |
How do I get the output to look like this? (I need to get the highest sortID for each of the ID and get that row alone)
ID | Name | City |
1 | xxx | Seattle |
2 | yyy | DC |
3 | zzz | Pittsburgh |
Solved! Go to Solution.
@shravanvijayaprasad - attached solution should help
@JosephSerpis thanks, this worked!