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