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.
[SQL Statement 1]
LIMIT [N];
where [N] is the number of records to be returned. Please note that the ORDER BY clause is usually included in the SQL statement.
| Store_Name |
Sales |
Txn_Date |
| India |
1500 |
Jan-05-1999 |
| China |
250 |
Jan-07-1999 |
| Australia |
300 |
Jan-08-1999 |
| USA |
700 |
Jan-08-1999 |
This table include the details regarding the store details country wise.
SELECT Store_Name, Sales, Txn_Date
FROM Store_Information
ORDER BY Sales DESC
LIMIT 2;
In this query, we have restricted the details to be shown by only to the level of two rows.
| Store_Name |
Sales |
Txn_Date |
| India |
1500 |
Jan-05-1999 |
| USA |
700 |
Jan-08-1999 |
0 Comment(s)