Search
 
SCRIPT & CODE EXAMPLE
 

SQL

order by sql

//this_for_descending_order.. 
 SELECT * FROM TableName ORDER BY columnName DESC;
 // this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;
Comment

sort by sql

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

SQL ORDER BY ASC (Ascending Order)

SELECT *
FROM Customers
ORDER BY age ASC;
Comment

how to ascending order in sql

SELECT *
FROM employees
ORDER BY employees.employee_id DESC ;
Comment

SQL ORDER BY With WHERE

SELECT last_name, age
FROM Customers
WHERE NOT country = 'UK'
ORDER BY last_name DESC;
Comment

sql order

SQL order of execution defines the
execution order of clauses.

-Select
It starts execution with 
-from  (Choose and join tables to get base data)
after from
-where ( filters base data )
-group by (Aggregates base data)
-having (filters aggregated data)
-select (returns final data)
-order by (sorts the final data)
-limit (limits the returned data to a row count)

Only select and from are mandatory
Comment

sql order by

Used to sort the result data in ascending (default) or descending order
through the use of ASC or DESC keywords.
Example: Returns countries in alphabetical order.
SELECT * FROM countries
ORDER BY name;
Comment

SQL ORDER BY Clause

SELECT *
FROM Customers
ORDER BY first_name;
Comment

order by in sql

ORDER BY: is for sorting result
either in descending or ascending order.
Comment

PREVIOUS NEXT
Code Example
Sql :: sql delete caracter list 
Sql :: mysql grant grant option 
Sql :: null column to 0 in mysql 
Sql :: SET NOCOUNT ON; 
Sql :: mysql backup query 
Sql :: postgresql search object in array 
Sql :: ora-01109 database not open in oracle 19c 
Sql :: mysql update row 
Sql :: order by oracle 
Sql :: find duplicates mysql 
Sql :: postgres default user 
Sql :: mssql disable foreign key constraint 
Sql :: mysql how to store lat,lng 
Sql :: oracle trigger after logon on schema 
Sql :: sql limit results returned 
Sql :: start mysql 
Sql :: mysql error 1251 
Sql :: sql merge 
Sql :: how to truncate all table in mysql workbench 
Sql :: update from table tsql 
Sql :: mysql cashing error 
Sql :: how to change a column name in postgresql 
Sql :: script sql backup database sql server 
Sql :: if else in plsql 
Sql :: update query with between in mysql 
Sql :: mysql where not equal 
Sql :: SELECT exists sql 
Sql :: split string from comma in sql 
Sql :: update table disable constraint 
Sql :: myswql show full processlist 
ADD CONTENT
Topic
Content
Source link
Name
6+8 =