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, 4 months agoWadyba
5 months, 1 week agopukovnik
4 months, 3 weeks agobca123
Most Recent 3 weeks, 3 days agoNelita
1 year, 7 months agocadcadley
2 years agodexdinh91
2 years ago