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?
deptno in where clause does not relate to deptno column i emp table but dept table. So basically it's taking all managers from emp table(three of them), departments 10 and 20 from dept table and making cartesian product out of those.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Artur1991
Highly Voted 2 years, 7 months agoWadyba
8 months agopukovnik
7 months, 2 weeks agobca123
Most Recent 3 months, 1 week agoNelita
1 year, 10 months agocadcadley
2 years, 2 months agodexdinh91
2 years, 2 months ago