/SQL/Select first and last row mysql

Select first and last row mysql

Select last row mysql

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

4

Source: stackoverflow.com

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);

0

Similar codes

14 votes249 views3 answers
Alter foreign key
SQL
2 votes244 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
2 votes246 views1 answer
Oracle list grants on package
SQL
0 vote286 views2 answers
Sql unique
SQL
0 vote182 views1 answer
Denied
SQL
2 votes240 views1 answer
Removing view
SQL
0 vote249 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
4 votes257 views2 answers
Float postgres
SQL
6 votes233 views2 answers
Sql display max value
SQL
3 votes219 views1 answer
System.debug apex
SQL

Share