خرید بک لینک

Vote count: 0

I want to convert Subquery into Join, following is the subquery

SELECT employee_id, last_name, salary
FROM employees
WHERE salary > (SELECT AVG(salary)
FROM employees);

I wrote following join, but I am getting "ORA-00934: group function is not allowed here" error

SELECT e.employee_id,
  e.last_name,
  e.salary
FROM employees e
INNER JOIN employees average
ON(e.salary>AVG(average.salary));

asked 1 min ago

برچسب: نویسنده: استخدام کار تاريخ: شنبه 19 تير 1395 ساعت: 15:28

صفحه بندی