SQL ORDER BY Keyword

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL ORDER BY Keyword


❮ SQL Keywords Reference



ORDER BY


The ORDER BY command is used to sort the result set in ascending or descending order.


The ORDER BY command sorts the result set in
ascending order by default. To sort the records in descending order, use the
DESC
keyword.


The following SQL statement selects all the columns from the "Customers"
table, sorted by the "CustomerName" column:




Example



SELECT * FROM Customers
ORDER BY CustomerName;


Try it Yourself »



ASC


The ASC command is used to sort the data
returned in ascending order.


The following SQL statement selects all the columns from the "Customers"
table, sorted by the "CustomerName" column:




Example



SELECT * FROM Customers
ORDER BY CustomerName ASC;


Try it Yourself »



DESC


The DESC command is used to sort the data
returned in descending order.


The following SQL statement selects all the columns from the "Customers"
table, sorted descending by the "CustomerName" column:




Example



SELECT * FROM Customers
ORDER BY CustomerName DESC;


Try it Yourself »



❮ SQL Keywords Reference


Popular posts from this blog

Malaysia to Papua New Guinea by motorcycle?

List of Bhojpuri films

.name