cancel
Showing results for 
Search instead for 
Did you mean: 

Sql execute

munish
New Contributor

How a if else condition can be executed/written in a SQL execute snap? Like
if(condition)
do 1
else
do 2

1 REPLY 1

dimche_saveski
New Contributor III

Hello @munish
If else condition can be written in SQL execute snap with CASE statement. Example bellow:

Select EmployeeName,Salary
CASE
WHEN Salary > 70000 AND Salary < 100000 THEN ‘Senior’
WHEN Salary < 70000 THEN ‘Junior’
ELSE ‘Executive’
END as Position
from EmployeesTable