problema con el group by
Publicado por Jacob (1 intervención) el 15/04/2016 15:24:37
Estimados al realizar esta consulta me tira error en el group by, e tratado de solucionar el problema pero no he podido, favor su ayuda.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
select employees.employee_id,
employees.FIRST_NAME || ' ' || employees.last_name,
employees.salary,
employees.hire_date,
trunc(sysdate-employees.hire_date),
round(months_between(sysdate,employees.hire_date)),
round(months_between(sysdate,employees.hire_date)/12)
from employees
where employees.salary < avg(employees.salary)
group by employees.employee_id,
employees.FIRST_NAME, ' ', employees.last_name,
employees.salary,
employees.hire_date,
trunc(sysdate-employees.hire_date),
round(months_between(sysdate,employees.hire_date)),
round(months_between(sysdate,employees.hire_date)/12)
Valora esta pregunta
0
