mysql> select empno from emp; +-------+ | empno | +-------+ | 7369 | | 7499 | | 7521 | | 7566 | | 7654 | | 7698 | | 7782 | | 7788 | | 7839 | | 7844 | | 7876 | | 7900 | | 7902 | | 7934 | +-------+ 14 rows in set (0.00 sec) mysql> select empno from emp limit 5,5; +-------+ | empno | +-------+ | 7698 | | 7782 | | 7788 | | 7839 | | 7844 | +-------+ 5 rows in set (0.00 sec)