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

3 votes322 views2 answers
Synonym oracle
SQL
3 votes313 views2 answers
Oracle sql first day of month
SQL
1 vote318 views3 answers
Reseed sql table primary key
SQL
2 votes292 views1 answer
Q operator in sql
SQL
2 votes294 views2 answers
Created at and updated at in mysql
SQL
13 votes277 views4 answers
Mysql select last 10 rows
SQL
0 vote313 views1 answer
Plsql check how much space all databases are consuming
SQL
2 votes286 views1 answer
Get first n letter of department name in sql
SQL
0 vote304 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote306 views1 answer
Grant privileges of databse to user
SQL