Saturday, February 1, 2014

get unique sort result ids



ID SORT
2000001 1
2000054 1
2000161 1
2004102 1
2000126 8
2000161 8
2004102 8
2000001 51
2000054 51
2000161 51
2004102 51
2000126 58
2000161 58
2004102 58


Output

ID SORT
2000001 1
2000054 1
2000161 1
2004102 1
2000126 8
2000161 8
2004102 8

we want all unique ID values with minimum sort values


No comments:

Post a Comment