Breaking News: Grepper is joining You.com. Read the official announcement!

SQL ORDER BY Clause

Add Answer

SAMER SAEID answered on October 2, 2020 Popularity 10/10 Helpfulness 2/10

answer SQL ORDER BY Clause

related order by sql

related sort by sql

related SQL ORDER BY With WHERE

related sql order by

related select sql order

related SQL Order by

related order by in sql

related sql statements order

SQL ORDER BY Clause

Comment

SELECT *
FROM Customers
ORDER BY first_name;

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: clause sql sql-order-by

Link to this answer
Share Copy Link

Contributed on May 20 2022

SAMER SAEID

0 Answers Avg Quality 2/10

Closely Related Answers

order by sql

Comment

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

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 02 2020

Nutty Nightingale

0 Answers Avg Quality 2/10

sort by sql

Comment

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

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 09 2021

VasteMonde

0 Answers Avg Quality 2/10

SQL ORDER BY With WHERE

Comment

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

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 20 2022

SAMER SAEID

0 Answers Avg Quality 2/10

sql order by

Comment

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;

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Lorenzo Satta Chiris

0 Answers Avg Quality 2/10

select sql order

Comment

-1

SELECT naslov, stranice AS broj
FROM knjige
ORDER BY broj DESC

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.webnstudy.com

Tags: select se

Link to this answer
Share Copy Link

Contributed on Jun 08 2021

Xerothermic Xenomorph

0 Answers Avg Quality 2/10

SQL Order by

Comment

select employee.name , employee.salary 
from employee
order by employee.name;

--or 

select employee.name ,employee.salary 
from employee
order by 1 ;

-- 1 = represent the first column following the select clause

--last one ordered by other columns not in the select clause but existing in the table
--For example, the employee table contains the id, name, salary, and date_of_barth.

select employee.name , employee.salary 
from employee
order by employee.date_of_barth;

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Feb 27 2023

Abdullrhman elhelw

0 Answers Avg Quality 2/10

order by in sql

Comment

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

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

sql statements order

Comment

-- SQL statements order
SELECT -> FROM -> WHERE -> GROUP BY -> HAVING -> ORDER BY -> LIMIT

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql statements stat

Link to this answer
Share Copy Link

Contributed on Jun 08 2024

Ugliest Unicorn

0 Answers Avg Quality 2/10

SQL ORDER BY Clause

Contents

More Related Answers

SQL ORDER BY Clause

Closely Related Answers

order by sql

sort by sql

SQL ORDER BY With WHERE

sql order by

select sql order

SQL Order by

order by in sql

sql statements order

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.