/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 vote201 views2 answers
Postgresql get last 10 records
SQL
0 vote316 views1 answer
Oracle convert int to date
SQL
0 vote195 views1 answer
Jdbc sql connection string
SQL
0 vote243 views1 answer
Mysql grant user wildcard database
SQL
1 vote212 views1 answer
Spark sql convert string to date
SQL
19 votes200 views5 answers
Date between in mysql
SQL
1 vote194 views1 answer
Mysql copy table1 to table2
SQL
0 vote195 views1 answer
Find most frequent value in SQL column
SQL
-1 vote184 views2 answers
On update cascade
SQL
5 votes197 views2 answers
Oracle find all tables with column name
SQL

Share