Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql order by alphabetical

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;		-- col1 DESC then col2 ASC
Comment

PREVIOUS NEXT
Code Example
Sql :: What is performance wise better join or a subquery ? 
Sql :: oracle calculate statistics on partition 
Sql :: call function sql oracle with output put line 
Sql :: mysql portable 
Sql :: how to fetch unique records from two tables 
Sql :: sql query tags 
Sql :: mysql extract number from string 
Sql :: use between operator in mysql 
Sql :: oracle exchange partition 
Sql :: selects all the columns from the sailors table 
Sql :: check psql validity function 
Sql :: difference between nvl and nvl2 in oracle 
Sql :: create sql table 
Sql :: dataframe lambda elif 
Sql :: install phpmyadmin pma 
Sql :: java mysql swing example 
Sql :: Oracle Function call - 12C 
Sql :: oracle sql how to overcome 999 limit for IN 
Sql :: sum over partition by postgresql 
Sql :: edit shchima table in sql 
Sql :: SQL-Arten 
Sql :: Aktor yang pernah terlibat di film bergenre Aksi di sql 
Sql :: how to know if table in rigt or left in sql 
Sql :: optimize sql query 
Sql :: how to get alternate records from a table in sql 
Sql :: what is a stored procedure 
Sql :: connecting fastapi to mysql server 
Sql :: sql id serial primary key 
Sql :: mysql install windows 10 
Csharp :: unity change tag in script 
ADD CONTENT
Topic
Content
Source link
Name
3+5 =