Multiple CASE conditions in SQL Server

By 2nd January 2019SQL

We can add multiple case condotions with multiple when and then keywords

Ex :

CASE
WHEN PKID=0 THEN SELECT 1
WHEN PKID=1 THEN SELECT 2
END

You should add END Keyword when you complete your case conditions.

Leave a Reply