Posted by Plamen Ratchev on 03/12/07 11:59

In addition to Greg's comments, this is why you can use TOP 1 and then based
on the ORDER BY define what you need to be selected in the result set.

Or maybe you mean the last inserted row... But a table is unordered set. You
would have to use a column that can determine what the last inserted row is
(the latest ID, date/time stamp, etc.).

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Performance of Partition Merge in 2005
• Prev in forum: CREATE VIEW - script to automate column names?
• Thread view: Re: get value of last item in column?

[Reply to this message]