Return Last Record in a Table 1

[mikemcginty]

If SELECT TOP 1 returns the first record in a table, how do you return the last record in a table?

Thanks

Mike

When you call out for help in the darkness, and you hear a voice in return, you're probably just talking to yourself again!

 

[amorous]

Simple...change the order by clause

SELECT TOP 1 from yourtable ORDER BY recordID Asc

will give you the first record

AND

SELECT TOP 1 from yourtable ORDER BY recordID DESC

Will give you the last record


-VJ