/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 votes300 views1 answer
Mysql now format
SQL
0 vote306 views1 answer
Sql out file formate
SQL
0 vote264 views1 answer
Como leer datos de mysql esp32
SQL
0 vote319 views1 answer
Mysql command line top 10
SQL
1 vote323 views1 answer
Liquibase alter column type / length
SQL
5 votes294 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote335 views1 answer
Postgres see sequence current state
SQL
0 vote305 views1 answer
Get a list of tables and the primary key
SQL
1 vote352 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote271 views1 answer
Can we drop a primary key
SQL

Share