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

Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA