Posted by Plamen Ratchev on 03/07/07 17:54

You can use TOP 1 to return only 1 row (based on the ORDER BY), something
like this:

SELECT TOP 1 COLUMN FROM TABLE ORDER BY COLUMN DESC

Also, MIN(COLUMN) and MAX(COLUMN) may work depending on how you define last
item, like:

SELECT MAX(COLUMN) FROM TABLE

Regards,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Simple SQL Help
• Prev in forum: get value of last item in column?
• Thread view: Re: get value of last item in column?

[Reply to this message]