/SQL/Sql reverse order of results

Sql reverse order of results

Sql reverse order of results

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

0

Source: stackoverflow.com

Similar codes

5 votes129 views3 answers
Sql server utc to local
SQL
0 vote123 views1 answer
How to display value of variable in mysql
SQL
0 vote112 views1 answer
Mysqldump don't drop table
SQL
0 vote112 views1 answer
How to find the most occuring in SQL
SQL
2 votes121 views1 answer
Set username and password for postgresql database
SQL
-1 vote118 views1 answer
Capitole toulouse
SQL
0 vote107 views1 answer
Remove default constraint sql server
SQL
-1 vote162 views1 answer
Difference berween database and data base management system
SQL
23 votes128 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote166 views2 answers
Fanyi
SQL

Share