Case Statement in SQL Server 2012

Introduction

In this article I described the Case Statement in SQL Server. The Case Statement manipulates the presentation of data without altering the actual data.

First of all we create a table.

Creation of table stu:

create table stu(stuName varchar(15), StuPersantage int)

Insertion of data:

insert into stu
select 'Ram',50 union all
select 'Ravi',55 union all
select 'Raj',59 union all
select 'Rozy',65 union all
select 'Raman', 70 union all
select 'Rocky',75 union all
select 'Ramesh',60 union all
select 'Rohen',45 union all
select 'Ravinder',25

Output:

select *  from stu



Case:

The Case Statement is a conditional statement and provides logic like an if/else statement for the SQL Command. With the help of the Case Statement we use when-then-else functionality in SQL Statements. It checks a condition; when the condition is met then one task is done else a different one is done.

Syntax:

Case expression
when expression1 then expression1
when expression2 then expression2
.................................
else expression
end

Example:

select stuName, StuPersantage,
'StuStatus'=case
when StuPersantage>=60 then 'first'
when StuPersantage>= 50 and StuPersantage< 60 then 'Second'
when StuPersantage>=30 and StuPersantage < 50 then 'Third'
else 'Fail'
end
from stu

Output:



Summary:

In this article I described the Case Statement in SQL Server. I hope this article has helped you to understand this topic. Please share if you know more about this. Your feedback and constructive contributions are welcome.