Forum Discussion
dimche_saveski
5 years agoNew 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