/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

1 vote192 views1 answer
How to set up a trigger in sql
SQL
0 vote172 views1 answer
Oracle locked objects
SQL
36 votes180 views6 answers
Delete from where sql
SQL
0 vote180 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote182 views1 answer
Get the previous column of a table in mysql
SQL
0 vote184 views1 answer
Oracle calculate statistics on partition
SQL
6 votes238 views2 answers
Install psql mac
SQL
0 vote199 views1 answer
Sql select lowest value row
SQL
0 vote168 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote200 views1 answer
Renommer base sql
SQL

Share