/SQL/Select first and last row sql

Select first and last row sql

Select first and last row sql

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

Similar codes

1 vote347 views1 answer
How do you use sql in you company
SQL
0 vote369 views1 answer
Check if string is a number sql
SQL
0 vote306 views1 answer
CREATE MULTIPLE FK
SQL
0 vote369 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
7 votes362 views3 answers
Add primary key to database sql
SQL
0 vote335 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote363 views1 answer
Alter boolean column postgresql
SQL
8 votes356 views3 answers
Connect python to mysql
SQL
1 vote350 views1 answer
Multiple count in sql
SQL
2 votes340 views1 answer
Brew start postgres manual
SQL

Share