Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql sort descending

SELECT * FROM table_name ORDER BY col1 ASC;				-- ASCending is default
SELECT * FROM table_name ORDER BY col1 DESC;			-- DESCending
SELECT * FROM table_name ORDER BY col1 DESC, col2 ASC;	-- col1 DESC then col2 ASC
Comment

mysql order

SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC 
Comment

ascending order mysql

  
 SELECT 
   column_name1, column_name2, column_name3
FROM 
   table_name
ORDER BY 
   column_name1 [ASC|DESC], 
   column_name2 [ASC|DESC],
   ...;
Comment

PREVIOUS NEXT
Code Example
Sql :: postgres set default schema 
Sql :: order by sql 
Sql :: oracle all tables 
Sql :: check if table exists oracle 
Sql :: what is my mysql version 
Sql :: delete record mysql query 
Sql :: sql server set variable if exists 
Sql :: truncate statement in sql 
Sql :: check if record exists mysql 
Sql :: django mssql backend 
Sql :: Configure postgresql engine for your django application 
Sql :: oracle drop index if exists 
Sql :: install mysql in ubuntu 
Sql :: mysql show table structure 
Sql :: find a column in all tables mysql 
Sql :: snap remove mysql workbench 
Sql :: permission denied postgres copy csv command line 
Sql :: connect to ssms with python 
Sql :: Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. 
Sql :: mysql create database utf8 
Sql :: drop row pgadmin 
Sql :: create a view in sqlite 
Sql :: install sqlite npm 
Sql :: oracle timestamp to date 
Sql :: sql get month from date 
Sql :: oracle pagination query offset 
Sql :: sql convert date to string yyyy-mm-dd 
Sql :: mysql event last execution 
Sql :: add primary key with auto increment to existing table column mysql 
Sql :: kill session inactive oracle 
ADD CONTENT
Topic
Content
Source link
Name
7+2 =