query with 'unique' limit

poring

I have a table that's like this:

id | year

8 | 2003
7 | 2003
6 | 2001
5 | 2000
4 | 2000
3 | 2000
2 | 1998
1 | 1996

I want to make a query which selects all the rows that have the last three years.
So for exemple this query applyed on the table above would return the 6 top rows.

Can this be done in one query? (I use mysql)

Thanks

nnichols

SELECT * 
FROM tbl 
WHERE year >= 2000
ORDER BY year DESC

Hope this helps

poring

Thanks, but that will not work. The exemple I gave is really just an exemple. In reality I have no way to know that the year has to be > 2000, it could be anything else.

I tryed the following query:

SELECT id FROM table ORDER BY id DESC LIMIT 3 DISTINCT year

but the syntax doesn't seem to be right. I'm sure it's possible though.

Thanks

nnichols

No, the syntax is definitely incorrect. What exactly do you want to return. Give more than one example as your previous example is very open to interpretation.

nnichols

No, the syntax is definitely incorrect. What exactly do you want to return. Give more than one example as your previous example is very unclear.

You could always use-

SELECT * 
FROM tbl 
WHERE year BETWEEN min AND max
ORDER BY year DESC