For those MS-SQL guys who searched on Google using the phrase "show last record query" or something like that AND you found this thread on tek-tips.com, then here is your answer:
SELECT *
FROM mytable
WHERE my_id=(SELECT MAX(my_id) FROM mytable)
This query will show the last record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.