-- Find all employees who earn more than the average salary of the entire company.
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...
Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...
1️) Scalar Subquery in SELECT: SELECT e.emp_id, e.emp_name, e.salary, (SELECT ROUND(AVG(salary), 2) FROM employees WHERE dept_id = e.dept_id) AS dept_avg_salary FROM employees e; 2️) Correlated ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results