/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 vote342 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote355 views1 answer
Mysql grouping functions
SQL
0 vote295 views1 answer
Update sql join multiple tables
SQL
0 vote376 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote351 views1 answer
How to connect postgresql database with java
SQL
0 vote371 views5 answers
Sql table intermédiaire
SQL
0 vote370 views1 answer
Ms sql filter all sympbol
SQL
0 vote347 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote345 views1 answer
Mysql select where field is a value
SQL
0 vote453 views1 answer
How to subquey to do not load in live database in
SQL

Share