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

8 votes172 views3 answers
Postgres connection string
SQL
0 vote176 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote175 views1 answer
Sometimes i cant edit sql developer
SQL
25 votes188 views6 answers
Import database mysql command line
SQL
0 vote179 views1 answer
Mysql utc timestamp
SQL
0 vote245 views1 answer
How to check common records in 2 table
SQL
24 votes193 views4 answers
Postgres delete database
SQL
0 vote176 views1 answer
Mysql persistence.xml
SQL
2 votes176 views1 answer
Sql server: select column values as comma separated string
SQL
2 votes168 views2 answers
How to rename column name in sql server using query
SQL