Answers for "select first row mysql"

how to get first 10 records of a table in mysql

SELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;

Posted by: Guest on January-20-2021

select first and last row mysql

(select *from DemoTable694 order by EmployeeId ASC LIMIT 1)
UNION
(select *from DemoTable694 order by EmployeeId DESC LIMIT 1);

Posted by: Guest on April-20-2021

Code answers related to "select first row mysql"