Global Web Forum

husnain

Administrator

From: Chichawatni,Pakistan

Registered: 2014-10-03

Posts: 8,129

Website

Legal Queries:

Oracle Quizzes Oracle

Question:
Which of the following queries are legal?

Option A):
SELECT deptno, avg(sal) FROM emp GROUP BY deptno;
Option B):
SELECT deptno, count(deptno) FROM emp GROUP BY ename;
Option C):
SELECT deptno, avg(sal) FROM emp;
Option D):
SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;

Correct Answer is Option A):
SELECT deptno, avg(sal) FROM emp GROUP BY deptno;

---

You cannot discover the new oceans unless you have the courage to lose the sight of the shore.