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

1 vote404 views1 answer
How to see logical reads in sql server
SQL
2 votes376 views2 answers
Mysql add hours to time field
SQL
0 vote342 views1 answer
Back up stored procedures mysql
SQL
0 vote366 views1 answer
Starting mysql shell lampp ubuntu
SQL
7 votes359 views1 answer
Sql server convert string to date
SQL
0 vote359 views2 answers
Cascade syntax in sql
SQL
0 vote346 views1 answer
Sql combine results from two tables
SQL
0 vote351 views2 answers
Mysql add days to date
SQL
1 vote374 views1 answer
Spark sql convert string to date
SQL
0 vote383 views1 answer
Mysql random number between 1 and 100
SQL