LIMIT

1. SELECT title FROM books LIMIT 3;
2.  
3. SELECT title FROM books LIMIT 1;
4.  
5. SELECT title FROM books LIMIT 10;
6.  
7. SELECT * FROM books LIMIT 1;
8.  
9. SELECT title, released_year FROM books
10. ORDER BY released_year DESC LIMIT 5;
11.  
12. SELECT title, released_year FROM books
13. ORDER BY released_year DESC LIMIT 1;
14.  
15. SELECT title, released_year FROM books
16. ORDER BY released_year DESC LIMIT 14;
17.  
18. SELECT title, released_year FROM books
19. ORDER BY released_year DESC LIMIT 0,5;
20.  
21. SELECT title, released_year FROM books
22. ORDER BY released_year DESC LIMIT 0,3;
23.  
24. SELECT title, released_year FROM books
25. ORDER BY released_year DESC LIMIT 1,3;
26.  
27. SELECT title, released_year FROM books
28. ORDER BY released_year DESC LIMIT 10,1;
29.  
30. SELECT * FROM tbl LIMIT 95,18446744073709551615;
31.  
32. SELECT title FROM books LIMIT 5;
33.  
34. SELECT title FROM books LIMIT 5, 123219476457;
35.  
36. SELECT title FROM books LIMIT 5, 50;