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 vote186 views1 answer
Sql datediff db2
SQL
0 vote189 views1 answer
Mysql jdbc timezone
SQL
0 vote202 views1 answer
Oracle date winter time
SQL
12 votes187 views4 answers
SQL Where
SQL
10 votes182 views4 answers
Join with multiple conditions sql
SQL
0 vote191 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote245 views2 answers
Dbms interview questions
SQL
0 vote192 views1 answer
Sql query contains multiple ids
SQL
1 vote195 views2 answers
How to enable error squiggles in vs code
SQL
2 votes207 views3 answers
Sql interview query questions
SQL