Define CASE in SQL with its Syntax?

Question

Sushant Mishra · Answer

In SQL CASE is used to provide if-then-else type of logic to SQL. It supports two formats, One is a Simple CASE expression, where we compare an expression to static values and the second is a Searched CASE expression, where we compare an expression to one or more logical conditions Simple Case Expresseion Syntax Searched case Expression Syntax

interview

Define CASE in SQL with its Syntax?

Can you answer this question?

1 Answers