Select LAST record in DB!??????

[jesus4u]

How the heck in a SQL statement can I select the LAST record in my DB?
thanks

[TheBionicOrange]

There isn't a SQL command for getting the last record.

The only way would be to grab the entire collection and use .MOVELAST.

[RoyceWindsor1]

SELECT * FROM tablename WHERE key_column = (SELECT MAX(key_column) FROM tablename)

[TheBionicOrange]

That will work, as long as you have got unique keys.

[TheBionicOrange]

Actually that won't work

the MAX clause is quantitive, and not chronological, therefore you would only return the record with the highest value, and not necessarily the last record.

If you have a time stamped field you could use the MAX clause on this to achieve the desired effect.

[Static]

go with the MOVELAST command. that will always work.

[Serge]

This will work in SQL Server, Access and Sybase:

Select Top 1 * From MyTable Order By FieldId Desc

[Static]

ahh good thinking serge.... TOP with a sort by Desc(ending) would work perfectly.

[TheBionicOrange]

I bow to your experience o wise one

[jesus4u]

Originally posted by Serge
This will work in SQL Server, Access and Sybase:

Select Top 1 * From MyTable Order By FieldId Desc

thank you all for your comments. They all work especially Serge's idea!