You can't corralate scalar subquery expression with outer query. This is the point. Main difference between scalar subquery expression and corraleted subquery expression is that the first one can't be join. If you join scalar subquery expression automaticly it changes in corraleted subquery expression.
Correct: A,B.
Surely you can correlate, the alternative says you CANT, correlate is not only JOIN
select * from employees e
where maximum_permitted_absence < (select sum(days_absent) from absences a where a.emp_id = e.emp_id)
upvoted 1 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
lucemqy
8 months, 3 weeks agoCyberP
1 year, 2 months agoalic_alex
1 year, 4 months agokarols32
1 year, 3 months agomrcsp
5 months, 3 weeks ago