a) Avg(salary) should not be selected
b) Dept_id should not be used in group by clause
c) Misplaced group by clause
d) Group by clause is not valid in this query
var adpushup = window.adpushup = window.adpushup || {}; adpushup.que = adpushup.que || []; adpushup.que.push(fun
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
var adpushup = window.adpushup = window.adpushup || {}; adpushup.que = adpushup.que || []; adpushup.que.push(fun
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!