group by

[Anon]

hi,

I have a sql statement below:

SELECT * FROM tblDelayTimeTable GROUP BY race ORDER BY id ASC, race ASC

assume: 'id' for record 1 = 4
'id' for record 2 = 5

There is 2 record inside this table. When using group by, it will return me the 'id' it get from the last record, which is 5. How can i get the first record of this id, in group by condition?

Thanks
Louis

[Anon]

The group by clause is used for aggregate functions, e.g., sum(), which you are not using in your select statement. Get rid of the "group by" and just use the order by clause.

Hank

[eklee]

Hi,

The purpose I use group by is I dont' want to show duplicate result on this select statement, based on the 'id'. Is the anyway i can do?

Thanks
Louis