Section 20 : MySQL - Sorting Data using ORDER BY
In this tutorial, you will learn how to sort a result set using the MySQL ORDER BY clause.
Introduction to MySQL ORDER BY clause
When you use the SELECT statement to query data from a table, the result set is not sorted. It means that the rows in the result set can be in any order.
To sort the result set, you add the ORDER BY clause to the SELECT statement. The following illustrates the syntax of the ORDER BY clause:
SELECT
select_list
FROM
table_name
ORDER BY
column1 [ASC|DESC],
column2 [ASC|DESC],
...;
Github link for sql quereis
https://github.com/RitaJain/SQL
See Complete Playlists
SQL for Beginners :https://www.youtube.com/playlist?list...
Interview Questions : • SQL Interview Questions
SQL : • SQL
Manual Testing : • Manual Testing
Connect & Contact Me:
Facebook: / 874154043395675
Quora: https://www.quora.com/profile/Rita-Ja...
Instagram: / ritajainid
Twitter : / ritajain1
Linkedin : / jainrita
Website :https://ritajain.wordpress.com/
#ritajainlectures
#freeSQLTutorial
#SortingDataUsingSQL
#OrderByClauseMySQL
#UsageofOrderBy
#SQLQueryUsingOrderBy
#SortingDataInMySQL
#Query
#dbmstutorials
#databasetesting
#sql
#MySQL
#SQLtutorialfor beginners
#mysqlworkbench
