Chapter 6 – SQL SERVER Order By Clause | SQL SERVER sorting in Hindi
Below topics has been covered in above video:
- Order by clause
- sorting sql server asc desc
- Specifying a conditional order By Clause
In SQL SERVER Order By Clause is used to sort the result set in ascending or descending order. Order By Clause can only be used in SELECT Statement.
The Syntax of Order By Clause is:
SELECT Column_Name,Column_Name… FROM TABLE_NAME [WHERE CONDITION] [ORDER BY CLAUSE] [ASC|DESC]
If we does not specify ASC or DESC then SQL Server By Default Sort result set in Asc Limitations and Restrictions There is no limit to the number of columns in the ORDER BY clause, however, the total size of the columns specified in an ORDER BY clause cannot exceed 8,060 bytes.
Columns of type text, image, ntext, geography, geometry, and xml cannot be used in an ORDER BY clause. If a table name is aliased in the FROM clause, only the alias name can be used to qualify its columns in the ORDER BY clause. Column names must be unique Null values are treated as the lowest possible values
1 thought on “Chapter 6 – SQL SERVER Order By Clause | SQL SERVER sorting in Hindi”
Hey very nice web site!! Guy .. Excellent .. Superb .. I’ll bookmark your web site and take the feeds additionally?KI’m glad to seek out so many helpful information right here in the put up, we’d like develop more strategies in this regard, thank you for sharing. . . . . .