Why is the following statement erroneous? SELECT d...
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state
APSC Prelims previous year questions

Why is the following statement erroneous? SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;

Asked in APSC 66 12/ Junior Manager (Electrical / Mechanical / IT/ INSTRUMENTATION) , in Assam Power Generation Corporation Limited (APGCL) (Advt. No. 12/, dtd 25-04-) ELECTRICAL ENGINEERING ME 2023

  1. Dept_id should not be used in group by clause
  2. Group by clause is not valid in this query
  3. Avg(salary) should not be selected
  4. None of the above
Show answer

Answer: D. None of the above

More APSC Prelims previous year questions questions

All 7,314 APSC Prelims previous year questions questions →