[altarek]

hello

i have table like this and want to display the row of last date (repeated id)
for example want to have row (2007 and 2009)

id |date
-----------
1 | 2005
1 | 2007
2 | 2008
2 | 2009
any help

[Nico]

SELECT date FROM table ORDER BY date DESC LIMIT 1

[altarek]

This returns a single result and I want to retrieve a single result for each duplicate id
i want to retrieves rows with years(2007 and 2009)

[Nico]

Okay, sorry! Give this a try

Code:

SELECT DISTINCT `date` FROM `table` ORDER BY `date` DESC LIMIT 2

[altarek]

and if duplicated id more than 2 or id i don't know number of duplicated id

[nafirici]

you could try order by and group by. It's not really what it's meant for, but it might work. I accidentally did this just yesterday while playing with a query, I ended up with a result set similar to what you're looking for. Also, you might want to look further into it, because the result set might not be guaranteed.