Which of the following queries are legal?

A. SELECT deptno, count(deptno) FROM emp GROUP BY ename;. Explanation: For aggregate functions group by clause is necessary.

Question #1330 of 749+ in Database Management System

📝 Question #1330

⌨️ Press A B C D to select

✓

All Options & Correct Answer

A SELECT deptno, count(deptno) FROM emp GROUP BY ename; Correct

B SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;

C SELECT deptno, avg(sal) FROM emp;

D SELECT deptno, avg(sal) FROM emp GROUP BY deptno;

📚 Want More?

749+ questions with detailed answers