>select table1.*; && or table1.id, table1.names, etc. > from table1; > join (select id, max(qty) as qty from table1 group by id) table2 on table1.qty = table2.qty >At the risk of looking foolish again.............
select table1.*; && or table1.id, table1.names, etc. from table1; join (select id, max(qty) as qty from table1 group by id) table2 on table1.id = table2.id AND table1.qty = table2.qty