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 vote156 views1 answer
Postgresql define pk sequence next number
SQL
-1 vote166 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
2 votes141 views1 answer
Oracle run_duration average
SQL
0 vote151 views2 answers
Nosqlbooster query other collection
SQL
0 vote149 views1 answer
Find most frequent value in SQL column
SQL
1 vote147 views1 answer
Psql autocomplete for mac brew install
SQL
1 vote165 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote112 views1 answer
Mysql show attributes of a table
SQL
0 vote228 views1 answer
Jpa generationtype sequence mysql
SQL
3 votes149 views2 answers
Mysql update row
SQL