/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

0 vote105 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote123 views1 answer
Sql server insert inner join
SQL
0 vote105 views1 answer
Original Query
SQL
1 vote100 views1 answer
Oracle list data files
SQL
0 vote126 views1 answer
Reindexing all tables sql server
SQL
0 vote95 views1 answer
List mysql tables and views
SQL
1 vote94 views1 answer
Sql only five first row
SQL
0 vote95 views1 answer
User defined variables in sql
SQL
26 votes111 views2 answers
Mysql workbench download
SQL
0 vote95 views1 answer
Group by 15 minute interval sql server
SQL

Share