Get only first row mysql

/**
To return only one row use LIMIT 1:
**/

SELECT *
FROM tbl_foo
WHERE name = 'sarmen'
LIMIT 1

/**
It doesn't make sense to say 'first row' or 'last row' unless you have an ORDER BY clause.
Assuming you add an ORDER BY clause then you can use LIMIT in the following ways:
To get the first row use LIMIT 1.
To get the 2nd row you can use limit with an offset: LIMIT 1, 1.
To get the last row invert the order (change ASC to DESC or vice versa) then use LIMIT 1.
**/

Source: stackoverflow.com

Similar codes

1 vote111 views1 answer
What is in condition in sql
SQL
0 vote111 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote150 views1 answer
Sqlite display headers on columns
SQL
0 vote115 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
-1 vote112 views1 answer
Auto increment psql not primary key
SQL
16 votes113 views2 answers
Oracle ddl
SQL
2 votes124 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote127 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes107 views3 answers
How to pass password mysql command line
SQL
0 vote104 views2 answers
Sql update top 100
SQL