SQL ORDER BY keyword – SQL TUTORIAL | Software Testing Material

SQL ORDER BY keyword:

SQL ORDER BY keyword is used to sort the data in ascending or descending order, based on one or more columns.

Syntax:

Example:

Order By – Ascending Order:

In the below image, you could find two SELECT statements. Second SELECT statement displays the records in Ascending order with respect to ‘Playername

SQL Order By Ascending

Order By – Descending Order:

In the below image, you could find two SELECT statements. Second SELECT statement displays the records in Descending order with respect to ‘Playername‘.

SQL Order By Descending

In the next tutorial, we will see How To Use GROUP BY in SQL

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

Sharing is caring.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Like This Post?

We have a lot more where that came from?

We only send really good stuff occasionally, promise.

Rajkumar

Leave a Comment

API Testing eBook

DOWNLOAD FOR FREE