How to select the record contains MAX(some_field) within GROUP(group by)
- by lovespring
SELECT MAX(some_field) FROM table_A GROUP BY another_field.
this only get the max value of the 'some_field', I wanna get the whole record which contains the MAX(some_field).
thanks.