Limiting the found set - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Limiting the found set

Message

From

05/07/2001 19:38:07

Eric Moreau
Moer Inc.
Deux-Montagnes, Quebec, Canada

05/07/2001 19:02:06

Keith Schuster
Mooresville, North Carolina, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Limiting the found set

Miscellaneous

Thread ID:

00527254

Message ID:

00527262

Views:

>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

Map

View

Click here to load this message in the networking platform