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

26 votes174 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote196 views1 answer
How to fetch alternate records from two tables
SQL
3 votes186 views2 answers
How to open postgresql in windows
SQL
0 vote190 views1 answer
Mysql a from on this page has
SQL
1 vote201 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote187 views1 answer
OFFSET consulta mysql
SQL
0 vote215 views1 answer
Typical max-connect-errors mysql
SQL
0 vote217 views1 answer
Get last inserted primary key
SQL
1 vote182 views4 answers
Postgres extract date from timestamp
SQL
0 vote181 views2 answers
Oracle create chain rule
SQL