/SQL/Sql sort ages

Sql sort ages

Sql sort ages

SELECT q.* 
    FROM (SELECT TOP 3 * 
              FROM table 
              ORDER BY id DESC) q
    ORDER BY q.id ASC

0

Source: stackoverflow.com

Similar codes

0 vote396 views1 answer
How to subquey to do not load in live database in
SQL
1 vote351 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote378 views1 answer
Reindexing all tables sql server
SQL
0 vote334 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes314 views1 answer
How to find constraints on a table in oracle
SQL
0 vote320 views1 answer
Count in sql and diff
SQL
29 votes314 views5 answers
Mysql show table structure
SQL
1 vote344 views2 answers
Sql server backup table
SQL
4 votes289 views2 answers
How to delete row in sql
SQL
0 vote297 views1 answer
Mysql group by derived column
SQL

Share