โ09-02-2020 05:38 PM
How a if else condition can be executed/written in a SQL execute snap? Like
if(condition)
do 1
else
do 2
โ09-09-2020 12:37 PM
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