How to use CASE statement in Order By Clause in SQL Server?

Question

Khushi Singh · Answer

The ORDER BY clause of SQL Server has an important option called CASE statement that enable the sorting of a query results depending on some conditions. Here's a simple explanation:
What is it used for?
The CASE statement helps you:
Arrange data in a manner different from other arrangements according to certain criteria.Use extensive reasoning as to how rows should order data sets.
Example:
Imagine you have a table called Products with two columns: ProductName and Category. You want to sort:
Any row that has its Category value equal to ‘Electronics’ should come first.Then sort the rest of them by ProductName in alphabetical order.
Here’s how you can do it:
SELECT ProductName, Category
FROM Products
ORDER BY 
   CASE 
       WHEN Category = 'Electronics' THEN 1
       ELSE 2
   END,
   ProductName;
Explanation:
The CASE statement assigns a value:
and to rows where Category = 'Electronics'.to all other rows.
SQL Server uses these values to sort rows in ascending order:
Rows with (Electronics) come first.Rows with come next.
Within each group, it sorts alphabetically by ProductName.
Key Points:
Just like any other place of the query, the CASE statement operates in the ORDER BY clause as well.You can use multiple sort conditions to have the type of sort order flexibility that you want.
This makes the CASE statement useful in dynamic sorting in the SQL query statement.
and 
and 
and 
and 
and 
and 
and 
and 
.

forum

How to use CASE statement in Order By Clause in SQL Server?

Ashutosh Kumar Verma

Can you answer this question?

1 Answers

Explanation:

Liked By