/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

13 votes329 views2 answers
Check if value is null mysql
SQL
2 votes346 views1 answer
Sql OR
SQL
0 vote315 views1 answer
Generate sequence number in sql server
SQL
0 vote336 views1 answer
Hibernate xml property MySQL url, username and password
SQL
1 vote346 views1 answer
Sql where last 12 months
SQL
0 vote354 views1 answer
Generate random & unique mysql string
SQL
-1 vote332 views1 answer
Add bool column in sql
SQL
0 vote332 views1 answer
Alter table myisam to innodb
SQL
51 votes446 views6 answers
Change column name sql
SQL
0 vote333 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL

Share