Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql reverse order of results

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

Sql reverse

SELECT column_name, REVERSE(column_name) as alias from table;

#example
select author_lname as forwards, reverse(author_lname) as backwords from books;
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle select 
Sql :: mysql trigger to delete old data 
Sql :: sql in operator 
Sql :: trigger sql server 
Sql :: Deleting data from tables 
Sql :: mysql null 
Sql :: How to automatically export database to a csv file 
Sql :: mysql run file command 
Sql :: aggregate functions 
Sql :: mysql replace empty string with null 
Sql :: like in sql 
Sql :: sqlite select regex 
Sql :: sql like operator 
Sql :: sqlite csv 
Sql :: how to link java and mysql 
Sql :: sql basic commands 
Sql :: mysql drop tables 
Sql :: restore backupfile discourse 
Sql :: SQL Syntax of RIGHT JOIN 
Sql :: mysql create link between tablesdatabase 
Sql :: First Step in installing SQL workbench 
Sql :: mysql remote connection macos 
Sql :: Priviledges on table from other schema 
Sql :: compare subqueries oracle 
Sql :: express api ith mysql data 
Sql :: postgresql not in alternative 
Sql :: and and or in where condition 
Sql :: amount of entries in a table psql 
Sql :: except in sql alchemy 
Sql :: get enginge db mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+8 =