Opposite of SELECT TOP?

Question

Transact-SQL has a handy SELECT TOP 4 [whatever] FROM.........

I want to make a SELECT query returning the last "n" entries from a table instead of the first ones.

This is the query I would use to return the first four items entered at the table, using SELECT TOP:

sql = "SELECT TOP 4 [news_title], [news_date_added], [news_short_description],
[news_ID] FROM [Web_Xtr_News] WHERE ([news_type] = 2 OR [news_type] = 3) AND
[news_language] = '" + Language + "' ORDER BY [news_ID] ASC"

I need to return the last four.

Answer 1

Change the order of the table from ASC to DESC.