To get the second record on mysql

 

To get the second record on mysql you can use LIMIT and OFFSET.

Syntax:

SELECT col FROM tbl LIMIT 1 OFFSET 1;

Example:

SELECT * FROM employer LIMIT 1 offset 2;

To get Third record in Mysql

Syntax:

SELECT col FROM tbl LIMIT 1 OFFSET 2;

Example:

SELECT * FROM employer LIMIT 1 offset 2;