The MySQL first function is used to return the first value of the selected column. Here, we use limit clause to select first record or more.
SELECT column_name FROM table_name LIMIT 1;
To SELECT FIRST element:
Consider a table named "officers", having the following data.
Execute the following query:
SELECT officer_name FROM officers LIMIT 1;
To SELECT FIRST two records
SELECT officer_name FROM officers LIMIT 2;