Case in SQL Server

Saranya Boopathi
Posted by Saranya Boopathi under Sql Server category on | Points: 40 | Views : 1431
Case in SQL Server

select BookId,BookName,Edition,
case when BookName like '%C#%' then '500'
when BookName like '%Java%' then '450'
when BookName like '%OOPS%' then '400' End as Price
from Book_details

Comments or Responses

Login to post response