MySQL FIRST
The MySQL FIRST function is used to get the first value of a column.
Syntax:
SELECT column,
FROM table_name
LIMIT num_rows;
SELECT column,
FROM table_name
LIMIT num_rows;
SELECT column, FROM table_name LIMIT num_rows;
Parameters:
num_rows: It is used to specify the number of rows to be displayed from the first row of the selected column.
Example 1: Students Table:
ID | NAME | AGE |
1 | Joy | 10 |
2 | Smiley | 13 |
3 | Happy | 11 |
4 | James | 13 |
5 | Bond | 10 |
Query:
SELECT name
FROM students
LIMIT 1;
SELECT name
FROM students
LIMIT 1;
SELECT name FROM students LIMIT 1;
Output:
NAME
Joy
1 row in set <0.00 sec>
NAME
Joy
1 row in set <0.00 sec>
NAME Joy 1 row in set <0.00 sec>
Explanation:
The ‘students’ is an already existing table. Here we are retrieving the first record of the ‘name’ column of the ‘students’ table.
Example 2: Students Table:
ID | NAME | AGE |
1 | Joy | 10 |
2 | Smiley | 13 |
3 | Happy | 11 |
4 | James | 13 |
5 | Bond | 10 |
Query:
SELECT name
FROM students
LIMIT 2;
SELECT name
FROM students
LIMIT 2;
SELECT name FROM students LIMIT 2;
Output:
NAME Joy Smiley
NAME Joy Smiley
NAME Joy Smiley
Explanation:
The ‘students’ is an already existing table. Here we are retrieving the first two records of the ‘name’ column of the ‘students’ table.