get last 10 records from a table 1

[kismet]

Hi! What sql command can I use in order to get the last 10 records of a table? One of the fields of the table is an AutoNumber. Other fields are dates, version numbers, etc.

Thank you in advance! =)

 

[Transcend]

It depends on what you consider the 'last' records to be, the last 10 autonumbers?? The highest 10 dates?

Try something like

SELECT TOP 10 *
FROM Table
ORDER BY ID <b>DESC</b>

Transcend

 

[kismet]

the last 10 autonumbers. =)

Thanks!! =)

 

[Transcend]

np, star?

Transcend

 

[kismet]

I'm not star. =)

 

[Transcend]

... i meant can i have one

Transcend