Skip to Main Content

CASE statement with multiple column in one when statment

in current sceniriao we are writing case statment like

currently

case [expression]

         when column_1= condition then true

             else false end

is it possible to write below syntex

case [expression]

         when (column_1,column_2) =(condition_1,condition_1)  then true

             else false end

Comments
Post Details
Added on May 15 2018
3 comments
38 views