Javatpoint Logo
Javatpoint Logo

MySQL first function

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.

Syntax:

MySQL first function example

To SELECT FIRST element:

Consider a table named "officers", having the following data.

mysql first() 1

Execute the following query:

Output:

mysql first() 2

To SELECT FIRST two records

Output:

mysql first() 3
Next TopicMySQL last




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA