Examine these two queries and their output: SELECT deptno, dname FROM dept; SELECT emame, job, deptno FROM emp ORDER BY deptno; Now examine this query: How many rows will be displayed?

The correct answer is B. 6. See the full explanation below for the reasoning.

Question

Examine these two queries and their output:

SELECT deptno, dname FROM dept; SELECT emame, job, deptno FROM emp ORDER BY deptno; Now examine this query:

How many rows will be displayed?

(43 responses)

No community discussion yet for this question.