top question 1

[lfc77]

I want to be able to view the last 50 records in a table, in both ascending and descending order. My problem is that

SELECT TOP 50 * FROM CALL_LOG ORDER BY ID DESC

gives the last 50 in descending order, but

SELECT TOP 50 * FROM CALL_LOG ORDER BY ID ASC

gives the FIRST 50 in ascending order.

How do I get the LAST 50 in ascending order?


Thanks,

Mike

 

[Sabnac]

SELECT * FROM CALL_LOG
WHERE ID IN
(SELECT TOP 50 ID FROM CALL_LOG ORDER BY ID DESC)
ORDER BY ID