get only first row mysql

Z. Kardzhaliyski answered on January 28, 2022 Popularity 9/10 Helpfulness 5/10

answer get only first row mysql

get only first row mysql

Comment

/**
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.
**/

Popularity 9/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: get mysql row sql

Link to this answer
Share Copy Link

Contributed on Jan 28 2022

Z. Kardzhaliyski

0 Answers Avg Quality 2/10

get only first row mysql

Contents

More Related Answers

get only first row mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.