SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
WITH AVG_SALATY AS( SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, AVG(SALARY) OVER () AVG_SALATY FROM EMPLOYEES ) SELECT * FROM AVG_SALATY WHERE SALARY > AVG_SALATY; SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, AVG(SALARY) OVER () AVG_SALATY FROM EMPLOYEES JOIN ( SELECT AVG(SALARY) AVG_SALATY FROM EMPLOYEES ) AVG_SALATY ON SALARY > AVG_SALATY; SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY, AVG(SALARY) OVER () AVG_SALATY FROM EMPLOYEES CROSS JOIN ( SELECT AVG(SALARY) AVG_SALATY FROM EMPLOYEES ) AVG_SALATY WHERE AVG_SALATY ON SALARY > AVG_SALATY;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear