Blog Posts - Top Clause



SQL TOP Clause

The TOP clause is used to specify the number of records to return.The TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on... SQL is a standard interactive and programming languag...
by Structured Query Language on Mar 28, 2012

SQL TOP Clause

Now we want to select only the two first records in the table above. We use the following SELECT statement: SELECT TOP 2 * FROM Persons Now we want to select only 50% of the records in the table above.
by Structured Query Language on Mar 2, 2012


Trending Topics

Close