Cacher is the code snippet organizer for pro developers

\!h Example 1: Find the rows that match a condition but only want to display the first 10 rows in a web page
SELECT track_name FROM track LIMIT 10;

\!h Example 2: you want five rows, but you want the first one displayed to be the sixth row of the answer set
SELECT track_name FROM track LIMIT 5, 5;
-- the output is rows 6 to 10.

\!h Example 3: you want all rows after a certain point, but don't know how many rows there are, pick a very large integer as the second parameter
SELECT track_name FROM track LIMIT 150, 999999999;
-- it's highly unlikely there are more rows than that, so this guarantess all rows are returned

\!h Example 4: alternative syntax
SELECT track_name FROM track LIMIT 10 OFFSET 5 -- as opposed to ...LIMIT 10, 5;