/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 votes125 views2 answers
Calculate percentage in sql
SQL
0 vote109 views5 answers
Linq cheat sheet
SQL
1 vote106 views1 answer
Primary key with prefix sql
SQL
3 votes130 views1 answer
Sql several or
SQL
1 vote106 views1 answer
Get rows affected mysql python
SQL
0 vote122 views1 answer
Make parameters nullable in sql server
SQL
2 votes156 views2 answers
Postgres drop column if exists
SQL
8 votes121 views1 answer
Oracle search text in all packages
SQL
0 vote114 views1 answer
Normalization in database 2nd normal form
SQL
7 votes105 views1 answer
Postgres base size
SQL

Share