select * from table1 join (select id, max(qty) as qty from table1 group by id) table2 on table1.qty = table2.qty

you need to be sure that qty is unique per names; otherwise you'll need another sub-query on max(date) or whatever.


>Sir I have these codes
>
>

>	CREATE CURSOR table1 (id int,names c(10),date d,qty int)
>	INSERT INTO table1 VALUES (1,"ADMIN",{^2017-02-19},25)
>	INSERT INTO table1 VALUES (1,"ADMIN",{^2017-02-20},21)
>	
>	INSERT INTO table1 VALUES (2,"GENERAL",{^2017-02-17},29)
>	INSERT INTO table1 VALUES (2,"GENERAL",{^2017-02-21},14)
>	
>	SELECT id,MAX(names),MAX(date),MAX(qty)from table1 GROUP BY id
>
>	brow
>

>
>it show these wrong result
>
>1 ADMIN 2/20/2017 25
>2 GENERAL 2/21/2017 29
>
>But I need this
>
>1 ADMIN 2/19/2017 25
>2 GENERAL 2/17/2017 29
>
>The date that has greater qty
>
>Later on I want to use these codes in SQLSERVER 2008
>
>Please help