How to Use Sub Query in Case Expression
This query returns “High” and “Low” based on their salary compared to the average salary of all employees. SELECT employee_id, first_name, CASE WHEN Salary>=(SELECT Avg(Salary) From Employees) THEN ‘High’ ELSE ‘Low’ …
How to Use Sub Query in Case Expression Read More