query on sql......a bit urgent

[yukeshean]

i have one table with the follwing recordset:

groupname price date
aaa 1.00 13/06/2002
aaa 2.00 01/07/2002
aaa - 01/06/2002
bbb 1.00 01/08/2002
cc 5.00 03/06/2002
cc - 18/05/2002

how to get all the frist row in each group (groupname) order by date desc?? means that i want to select the following result out.
aaa 2.00 01/07/2002
bbb 1.00 01/08/2002
cc 5.00 03/06/2002


Looking forward for help.....A bit urgent here. Please do give some advice. TQ in advance for ur help!

Regards,
yukeshean

 

[adaW]

try...

 SELECT DISTINCT groupname, price, date FROM TABLE_NAME ORDER BY date

 

[tlbroadbent]

Try this.

Select groupname, price, [date]
From tblname t
Where [date]=
(Select Max([date])
From tblname
Where groupname=t.groupname) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.