Home » SQL & PL/SQL » SQL & PL/SQL » group function
group function [message #596] Sat, 23 February 2002 13:41 Go to next message
hshah22222
Messages: 6
Registered: February 2002
Junior Member
Q: You develop the following SQL statement containing a group expression.Which line in the following select statement,when removed from the statement,will correct the error?

select deptno,avg(sal)
from emp
group by empno;

A. select deptno,avg(sal)
B.from EMP
C.group by empno;
D.There no errors in this statement,therefire no clauses should be removed.

What is the correct answer? and why?

Thank you.

Report message to a moderator

Re: group function [message #597 is a reply to message #596] Sat, 23 February 2002 16:29 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
correct stmt is :

select deptno,avg(sal)
from emp
group by deptno;

Report message to a moderator

Previous Topic: Create View won't work
Next Topic: NEED HELP - ASAP! invalid host/bind variable name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 20:19:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.