/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

0 vote160 views1 answer
Load utilities in sql server
SQL
5 votes250 views1 answer
Oracle asynchronous procedure
SQL
19 votes163 views6 answers
Sql create table
SQL
1 vote147 views1 answer
Can not connect to mysql server
SQL
5 votes143 views1 answer
Mysql get last day of month
SQL
0 vote156 views1 answer
Null column as zero in mysql
SQL
0 vote161 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote162 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote221 views1 answer
Insert column after column mysql
SQL
0 vote150 views1 answer
Mysql set column equal to another automatic
SQL

Share