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 vote208 views1 answer
Create another table from existing table sql oracle
SQL
0 vote200 views1 answer
List column names of multiple tables psql
SQL
50 votes226 views6 answers
Install mysql on ubuntu
SQL
-2 votes215 views1 answer
Trunc in sql
SQL
0 vote224 views1 answer
DATEDIFF minute postgres
SQL
1 vote207 views1 answer
Float precision in psql
SQL
18 votes202 views6 answers
Mysql create table
SQL
1 vote193 views1 answer
Oracle current sequence value
SQL
0 vote201 views1 answer
Mysql server not running
SQL
15 votes196 views2 answers
Open postgress in terminal mac
SQL