Message
General information
Fórum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
ID da thread:
00527254
ID da mensagem:
00527262
Views:
36
>What is the syntax to limit the found set of a standard query
>
>Say the actual record set has 100 records, I just want the first 10 returned
>
>Thanks

Select TOP 10 F1, F2 FROM Table1 ...
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Responder
Mapa
View