Select latest 3 records ONLY

[IClarke]

Anyone tell me the SQL query i need to use to do this ? I'm currently using :

SELECT Title, ID FROM NewsArticles WHERE ID > ((SELECT MAX(ID) from NewsArticles)-3) ORDER BY ID DESC

But if the ID fields are not consecutive for whatever reason it will select only 2 or even 1 record.

I'm sure it's something really easy ... i think i'm having a bad day !

Thanks in advance
Ian.

[Gaffer]

SELECT TOP 3 ID, Title FROM NewsArticles ORDER BY ID DESC