Total Page Preview:   000000002295

What is order by function in SQL in English and Hindi

 

SQL order by function in Engilsh

The "ORDER BY" function in SQL is used to sort the result set of a query in ascending or descending order based on one or more columns. Here's an example:

Suppose we have a table named "students" with the following columns:

To sort the students by their age in ascending order, we can use the following SQL query:

This will return a result set with the students sorted by their age in ascending order:

 

 

SQL order by function in Hindi

"ORDER BY" function SQL mai ek query hai jo result set ko ek ya ek se zyada columns ke basis par ascending ya descending order mai sort karta hai. Yahan ek example hai:

Maan lijiye ki humare paas "students" table hai jismein ye columns hain:\

Ab hum "students" table ko unke age ke basis par ascending order mai sort karna chahte hain. Iske liye hum is SQL query ka upyog kar sakte hain:
 
Ye humein ek result set deta hai jismein students unke age ke basis par ascending order mai sort kiye gaye hain:
 
 
 
 
 
 
 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments


                           
                           

                           

                           

Facebook User: