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.


MySQL first function example

To SELECT FIRST element:

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

mysql first() 1

Execute the following query:


mysql first() 2

To SELECT FIRST two records


mysql first() 3
Next TopicMySQL last

Youtube For Videos Join Our Youtube Channel: Join Now


  • Send your Feedback to

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA