Total Page Preview: 000000004578
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