/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

2 votes169 views1 answer
Search query in mysql
SQL
0 vote140 views1 answer
How to select an index in oracle sql
SQL
1 vote126 views1 answer
Show table columns
SQL
1 vote126 views1 answer
Mysql get character set
SQL
2 votes206 views1 answer
Postgresql group by month and year
SQL
1 vote120 views1 answer
Mysql count all table rows
SQL
0 vote135 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote146 views1 answer
Sub query in linq
SQL
4 votes144 views2 answers
Bulk kill mysql processlist
SQL
8 votes135 views1 answer
Oracle current date plus 1 month
SQL

Share