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

sort by sql

Add Answer

VasteMonde answered on October 2, 2020 Popularity 10/10 Helpfulness 4/10

answer sort by sql

related order by sql

related SQL ORDER BY ASC (Ascending Order)

related sql statements order

related SQL ORDER BY With WHERE

related sql order by

related SQL ORDER BY Clause

related SQL Order by

related sort result in sql

related sorting desc in sql

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

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

SQL ORDER BY ASC (Ascending Order)

Comment

SELECT *
FROM Customers
ORDER BY age ASC;

Popularity 10/10 Helpfulness 5/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 statements order

Comment

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

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql statements sta

Link to this answer
Share Copy Link

Contributed on Jun 08 2024

Ugliest Unicorn

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

SQL ORDER BY Clause

Comment

SELECT *
FROM Customers
ORDER BY first_name;

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: clause cl

Link to this answer
Share Copy Link

Contributed on May 20 2022

SAMER SAEID

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

sort result in sql

Comment

SELECT column1, column2, ... FROM table_name ORDER BY column_name ASC/DESC;

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 15 2023

Blasian

0 Answers Avg Quality 2/10

sorting desc in sql

Comment

order by statement in sql

Popularity 10/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sorting

Link to this answer
Share Copy Link

Contributed on May 07 2022

Clear Chinchilla

0 Answers Avg Quality 2/10

sort by sql

Contents

More Related Answers

sort by sql

Closely Related Answers

order by sql

SQL ORDER BY ASC (Ascending Order)

sql statements order

SQL ORDER BY With WHERE

sql order by

SQL ORDER BY Clause

SQL Order by

sort result in sql

sorting desc in sql

Grepper

Documentation

Social

Legal

Contact

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