SELECT TOP ??? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SELECT TOP ???

Message

From

25/07/2000 20:01:36

Mike Yeager
MikeYeager.com
Taos, New Mexico, United States

25/07/2000 19:43:50

Janis Booth
Webmd
Prospect, Connecticut, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SELECT TOP ???

Miscellaneous

Thread ID:

00396652

Message ID:

00396851

Views:

Well...

If the source table(s) can't produce the number of records:

SELECT TOP 10 FROM ACCOUNTS ORDER BY ACCT_NAME

and the table only has 3 records, you get three!

Mike

Map

View

Click here to load this message in the networking platform