<an*********@googlemail.comwrote in message
news:11**********************@n33g2000cwc.googlegr oups.com...
Thank you very much, but my question is more like how to get the exact
VALUE of the field (not the minimum or maximum)?
Not sure what you mean by the exact value of the field. How do you define
last item in column.
Generally that means the min or max value.
If you can give us some example data perhaps we can give a better solution?
>
is there a command/query for it?
On 7 mar, 18:54, "Plamen Ratchev" <Pla...@SQLStudio.comwrote:
>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 Ratchevhttp://www.SQLStudio.com
--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com
http://www.greenms.com