SQL > Advanced SQL >
By default, all results that satisfy the conditions specified in the SQL statement are returned. However, this may not always be what we want, as sometimes we only want to retrieve a subset of records. In MySQL, this is accomplished using the LIMIT keyword. The syntax for LIMIT is as follows:
[SQL Statement 1]
where [N] is the number of records to be returned. Please note that the ORDER BY clause is usually included in the SQL statement. Without the ORDER BY clause, the results we get would be dependent on what the database default is.
For example, we may wish to show the two highest sales amounts in Table Store_Information
we key in,
SELECT Store_Name, Sales, Txn_Date
ORDER BY Sales DESC
The SQL Server equivalent to LIMIT is TOP, which is covered next.