Case Statement in SQL Server 2012
In this article I described the Case Statement in SQL Server.
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 * from stu
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.
when expression1 then expression1
when expression2 then expression2
select stuName, StuPersantage,
when StuPersantage>=60 then 'first'
when StuPersantage>= 50 and StuPersantage< 60 then 'Second'
when StuPersantage>=30 and StuPersantage < 50 then 'Third'
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.