/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

10 votes359 views1 answer
Oracle dependencies table
SQL
1 vote357 views1 answer
Size of all tables in a schema oracle
SQL
0 vote328 views1 answer
Mysql command prompt date insert format
SQL
0 vote333 views1 answer
Difference between varchar and varchar2
SQL
0 vote346 views1 answer
Sql server list user permissions
SQL
3 votes329 views1 answer
Oracle apex message quit website
SQL
0 vote351 views1 answer
Kill a pid redshift
SQL
0 vote334 views1 answer
Mssql current date
SQL
1 vote348 views1 answer
Postgres check for foreign key
SQL
0 vote343 views1 answer
Drop all data from tables
SQL

Share