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 performance.
Note: Not all database systems support the TOP clause.
The "Persons" table:
Now we want to select only the two first records in the table above.
We use the following SELECT statement:
The result-set will look like this:
Now we want to select only 50% of the records in the table above.
Your Query was successfully sent!