please help me to solve the query

[Deven Oza]

Hello everybody,

I want Create a loop that will display the average salary by department id from the employees table. please help me. The employee table is as under.

EMPLOYEE_ID DEPARTMENT_ID SALARY
100 90 24000
101 90 17000
102 90 17000
103 60 9000
104 60 6000
107 60 4200
124 50 5800
141 50 3500
142 50 3100
143 50 2600
144 50 2500
149 80 10500
174 80 11000
176 80 8600


Thank you
Deven Oza

[michaelb]

This might work for you:

select DEPARTMENT_ID, avg(SALARY) from employees group by DEPARTMENT_ID;

[Deven Oza]

This might work for you:

select DEPARTMENT_ID, avg(SALARY) from employees group by DEPARTMENT_ID;

Thank you michael

But I want to solve that query using LOOP, thats why I am confuse. Please try for me.

thank you once again
Dev