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 vote233 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote202 views1 answer
Hibernate with springboot mysql
SQL
0 vote199 views2 answers
How to check if a column exists in a SQL Server table?
SQL
5 votes220 views1 answer
Oracle create table comment
SQL
24 votes194 views5 answers
Sql reset auto increment
SQL
0 vote200 views1 answer
Add sqlite3 in lumen
SQL
3 votes213 views2 answers
Truncate table
SQL
0 vote194 views1 answer
Alter table myisam to innodb
SQL
8 votes181 views1 answer
Oracle add month
SQL
1 vote309 views1 answer
Aqua Data studio postgresql ssl
SQL