/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 votes230 views2 answers
Mysql search for column name in all tables
SQL
2 votes213 views1 answer
Oracle index size
SQL
1 vote224 views1 answer
Mysql search like order by best match
SQL
0 vote219 views2 answers
Oracle sql for each row
SQL
0 vote211 views1 answer
Alter table fulltext
SQL
0 vote216 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote217 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote239 views1 answer
Sql today at midnight
SQL
0 vote206 views1 answer
10000000000000000000 am to meters
SQL
2 votes232 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL

Share