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

23 votes276 views1 answer
How remove column in mysql
SQL
0 vote245 views1 answer
Metada in sql
SQL
0 vote268 views1 answer
Mysql update from n to 100
SQL
0 vote287 views1 answer
C# get sql min date
SQL
0 vote259 views2 answers
Postgresql get long running queries
SQL
-1 vote290 views2 answers
Sql truncate number
SQL
6 votes323 views3 answers
Check if string contains substring sql
SQL
0 vote278 views2 answers
Tsql row number
SQL
0 vote359 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote263 views1 answer
Bigquery declare
SQL