/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 vote344 views1 answer
How to add boolean column in postgresql
SQL
1 vote334 views1 answer
Postgres start database on linux
SQL
0 vote312 views1 answer
Raiserror nowait sql server
SQL
0 vote338 views1 answer
Sql tablo sp
SQL
0 vote321 views1 answer
Check psql validity function
SQL
0 vote374 views1 answer
Add user mysql wordpress
SQL
0 vote377 views1 answer
Mysql workbench format date
SQL
0 vote381 views2 answers
How to install psql in ubuntu
SQL
7 votes354 views6 answers
Mysql group concat
SQL
0 vote324 views1 answer
Commit transaction sql
SQL

Share