Displaying last record

[Rya]

Hi this is a simple one, but I was just wandering if someone could help me to write an sql string that returns the last record. Similar too:
SELECT TOP 1 * FROM dbo.Question
But selecting the Bottom one.

Or maybe better returning the number of records rather than the last record.

 

[Transcend]

To return the number of records
use a select count(idfield) in your query

Transcend

 

[r937]

"last record" based on what? if the table has an IDENTITY column, it's easy

select top 1 *
from dbo.Question
order by IDfield descending


rudy

 

[kishleo]

well, what do you mean by last record? the record which is just inserted or updated? or the last record by physical storage? ô¿ô Kishore