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

0 vote304 views1 answer
Cahnge column name apex oracle
SQL
0 vote298 views1 answer
Nodejs sql get one to many relationship as array
SQL
48 votes321 views3 answers
Psql create database
SQL
21 votes268 views6 answers
Docker run mysql
SQL
11 votes273 views3 answers
Sqlite3 create table from another table
SQL
0 vote275 views1 answer
Oracle db get table sizes
SQL
1 vote290 views1 answer
Mysql show queries running
SQL
0 vote290 views1 answer
Alter table engine mysql
SQL
0 vote283 views1 answer
Pgsql is not permitted to log in
SQL
0 vote265 views1 answer
Mysqlimport
SQL