May 2019
Intermediate to advanced
546 pages
12h 41m
English
This specifies the maximum number of records you want to select. If the result in the query has more than this number of records, the LIMIT statement will limit your results list to this number. Sometimes, you can use it in conjunction with ORDER BY to showcase a top 5 or a top 10 list:
SELECT Name FROM Account LIMIT 5
Read now
Unlock full access