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 vote301 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes306 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote335 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
11 votes346 views1 answer
Creating tables in sql with python
SQL
2 votes305 views1 answer
Oracle index size
SQL
1 vote342 views1 answer
Set id count mysql
SQL
1 vote343 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
3 votes326 views4 answers
Psql list tables in schema
SQL
2 votes333 views3 answers
Row number mssql
SQL
2 votes320 views1 answer
Postgresql change value in column
SQL