/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

8 votes151 views1 answer
Mysql dump restore
SQL
0 vote144 views2 answers
PostgreSQL having
SQL
0 vote118 views1 answer
Openquery insert into linked server
SQL
7 votes132 views2 answers
How to create index mysql
SQL
1 vote144 views3 answers
SELECT * FROM
SQL
1 vote125 views1 answer
Sql run multiple updates in one query
SQL
0 vote128 views1 answer
Find all tables where column name exists oracle
SQL
0 vote130 views1 answer
How to connect to mysql in ef 6
SQL
0 vote148 views1 answer
How to define a non primary composite key in sql
SQL
0 vote137 views1 answer
Find duplicate users by email address in mysql
SQL

Share