Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select, which returns exact number of records
Divers
Thread ID:
00359207
Message ID:
00359207
Vues:
54
I have command "SELECT * FROM table WHERE ORDER BY ", which returns e.g. 100 records, but I want use first or last 10 records only. How to correct this command for this purpose? I donn't want to use "TOP 10" clause, because it can return more than 10 records. I want exactly 10 records (if exist, of course).