/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 vote178 views1 answer
Sqlcl format
SQL
5 votes151 views3 answers
Oracle first day of last year
SQL
15 votes159 views2 answers
How to know the username of postgresql
SQL
0 vote153 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote189 views1 answer
Grouping by email domain mysql
SQL
2 votes156 views4 answers
Mysql get all tables row count
SQL
1 vote158 views1 answer
Oracle apex run 404
SQL
1 vote143 views2 answers
Sql select only first occurrence
SQL
1 vote145 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote164 views1 answer
Insert value to new table by joining 2 different tables
SQL

Share