Answers for "how to use any opertor in sql server with real time example"

how to use any opertor in sql server with real time example

SELECT 
    first_name, 
    last_name, 
    salary
FROM
    employees
WHERE
    salary = ANY (
        SELECT 
            AVG(salary)
        FROM
            employees
        GROUP BY 
            department_id)
ORDER BY 
    first_name, 
    last_name,
    salary;   
Code language: SQL (Structured Query Language) (sql)