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 :: postgresql get date from datetime 
Sql :: select distinct after join 
Sql :: oracle free up space in tablespace 
Sql :: how to combine 2 tables in mysql 
Sql :: MYSQLI_ASYNC 
Sql :: sql select where in 
Sql :: remove auto increment mysql 
Sql :: delete db postgres 
Sql :: sort by mysql 
Sql :: SQL query to verify the size of the table 
Sql :: flask marshmallow sqlalchemy 
Sql :: sql count total by foreign key 
Sql :: enable full text search mysql 
Sql :: role "postgres" does not exist 
Sql :: sql sum show 0 result 
Sql :: mysql: command not found 
Sql :: sql server select furst day of current year 
Sql :: sequence postgresql 
Sql :: sum value by month sql 
Sql :: sql server pivot rows to columns 
Sql :: sql server convert to guid 
Sql :: ON DUPLICATE KEY UPDATE for postgres 
Sql :: postgresql linux password 
Sql :: SQL Copy to Another Database 
Sql :: oracle select invalid views 
Sql :: auto increment column in mysql query results 
Sql :: sql to array of objects 
Sql :: find log file postgresql linux 
Sql :: postgres create multiple index 
Sql :: SQL Server query to get data for a particular date and time 
ADD CONTENT
Topic
Content
Source link
Name
6+5 =