Hi friends,
I got a table as follows
Name | idNo | started | type | entrytype
-----------------------------------------------------------------
Nick | 12 | 12-02-2011 | 0 | 1
Sam | 14 | 13-02-2011 | 1 | 1
Paul | 12 | 14-02-2011 | 1 | 1
Jwal | 12 | 13-02-2011 | 1 | 1
------------------------------------------------------------------
I want to select using "DISTINCT" I wrote a query as follows
select distinct idNo from table where entrytype='1' order by started LIMIT 0,10
Working but I is not sorting the values according to "started" ( I mean by date )
The following query will sorting the data according to date ..
But I need distinct values .. Please help
select * from table where entrytype='1' order by started LIMIT 0,10
Thanks in advance
Rajeesh