SQL SERVER CASE PUZZLE QUERY
What would be the output of following query? 😄 SELECT CASE WHEN 1 = 1 THEN 'Vikas Ahlawat1' WHEN 2 = 2 THEN ...
https://www.interviewquestionspdf.com/2016/12/sql-server-case-puzzle-query.html
What would be the output of following query? 😄
SELECT CASE WHEN 1=1 THEN 'Vikas Ahlawat1'
WHEN 2=2 THEN 'Vikas Ahlawat2'
ELSE 'Vikas Ahlawat3' END AS Name
Ans:
interesting..
ReplyDeleteThanks
Deletefor more such questions you can follow this link http://www.interviewquestionspdf.com/2014/12/sql-server-interview-questions-and.html
CAN U PLEASE EXPLAIN...........
ReplyDeletecase is just as switch.. when first case is true then it get terminated from that point only.
ReplyDelete