query to grab great value in column for each id
Posted on 2009-07-15
Given a table of data such as this
how would you write a query that will return the the greatest value of the 2nd column (size) for EACH ID.
XL > L > M > S
The correct output would be:
It there a single, elegant query that can do such a thing?