Case Statement in SQL Server

Venkatesan Jayakantham
13y
2.6k
0
0

Blog

Case statement in SQL Server is a very handy one to showcase your output as expected or for customising your output, you can use Case statement. Please find a small example to get use of the case statement.

 

DROP TABLE 
VENKAT_TABLE

GO

CREATE TABLE VENKAT_TABLE(ID 
INT, NAME VARCHAR(100),MARKS 
INT)

INSERT INTO VENKAT_TABLE VALUES (1,'VENKAT',20)

INSERT INTO VENKAT_TABLE VALUES (2,'SUBA',80)

INSERT INTO VENKAT_TABLE VALUES (3,'LAKSHMI',45)

INSERT INTO VENKAT_TABLE VALUES (4,'SANTHI',70)

SELECT ID, NAME,

CASE WHEN MARKS >50 THEN 'GOOD'

ELSE 'BAD' 

END 



AS RESULT

FROM VENKAT_TABLE