November 2, 2004 at 12:49 pm
What is the equivalent of the Last() function in SQL Server 2000?
Definition:
LAST(column)
Returns the value of the last record in the specified field (not supported in SQLServer2K)
November 2, 2004 at 12:52 pm
While there is no "last record", you might have a look at MAX(), which should be the equivalent.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 2, 2004 at 2:40 pm
I am doing an access to SQL Server conversion of queries, and Last() is used on columns on string type, and I was not sure if you still could use MAX() in that case?
November 2, 2004 at 6:22 pm
MAX works fine on string columns.
February 8, 2006 at 12:37 pm
actually, Min and Max do not work just fine!
I am having the same issue...2 tables, looking for distinct rows where the thread number is min and can't seem to get the username unique...keeps giving me all unique usernames...
February 9, 2006 at 2:04 am
Please post your query, an example of the results you are getting and an example of the results you would like to get.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply