SQL Server

Create SQL Server simple CASE expression



 Like (0)  Dislike (0)

The following shows the syntax of the simple CASE expression

SELECT
CASE productStatus
WHEN 1 THEN 'Pending'
WHEN 2 THEN 'Processing'
WHEN 3 THEN 'Rejected'
WHEN 4 THEN 'Completed'
END AS productStatus,
COUNT(id) count
FROM
products
WHERE
YEAR(createdDatetime) = 2018
GROUP BY
productStatus;

0 Comment's

Comment Form

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example