Which line in the following SELECT statement will produce an error?Line1: SELECT dept, AVG(salary)Line2: FROM empLine3: GROUP BY empid;A. Line 1 and Line 2B. Line 3C. Only Line 1D. There are no errors in this statement.

Showing Answers 1 - 3 of 3 Answers

mukts

  • Feb 13th, 2006
 

D

  Was this answer useful?  Yes

bharathi

  • Feb 22nd, 2006
 

B

  Was this answer useful?  Yes

FREDDYfOX

  • Apr 7th, 2006
 

C

  Was this answer useful?  Yes

sandeep

  • Nov 7th, 2006
 

Freedy is right

answer is c

  Was this answer useful?  Yes

shivaleela

  • Dec 8th, 2006
 

c

since dept is not a GROUP BY EXPRESSION

  Was this answer useful?  Yes

pavanio

  • Sep 27th, 2007
 

B.line 3 is the answer. An Oracle error arises stating : "EMPID" invalid identifier.(ORA 00904)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions