/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

3 votes165 views3 answers
Start postgresql ubuntu
SQL
0 vote140 views1 answer
Postgres - Login and connect as default user
SQL
0 vote128 views1 answer
Change database name psql 8
SQL
0 vote140 views1 answer
Amount of entries in a table psql
SQL
47 votes216 views6 answers
Add column mysql
SQL
0 vote183 views1 answer
Oracle plsql sleep
SQL
2 votes182 views1 answer
Username sql
SQL
0 vote159 views1 answer
How to check database engine in mysql
SQL
0 vote140 views1 answer
Max mysql
SQL
0 vote147 views1 answer
Check if has alpha characters sql
SQL

Share