how to get last 10 records from SqlDataSource

Question

User231953124 posted

Hi all,

this is more SQL related question than ASP, however..

I want to show in GridView last 10 records from SqlDataSource.

SELECT TOP 10 - returns first 10 records, but I want the exact opposite: get last 10.

I tried also command:  SelectCommand="SELECT * FROM [Transaction] ORDER BY [IDtrans] LIMIT 10" but got an error Incorrect syntax near 'LIMIT'.

Any idea how to do it?

Thanks Mira

Answer 1

User-1360095595 posted

Try: SELECT TOP 10 * FROM [Transaction] ORDER BY [IDtrans] DESC

Answer 2

User231953124 posted

hmm thanks it works, just the last record is on the top, not on the bottom, but this isn´t big problem..

Answer 3

User-1360095595 posted

Try: SELECT * FROM [Transaction] WHERE IDtrans IN (SELECT TOP 10 IDtrans FROM [Transaction] ORDER BY [IDtrans] DESC) ORDER BY IDtrans