Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Examine the description of the EMPLOYEES table: Which two queries return all rows for employees whose salary is greater than the average salary in their department? (Choose two.) A. B. C. D. E.
Yes, it is allowed. It follows from the order of the execution. Since the engine would execute the subquery first, it already knows what the alias refers to.
upvoted 3 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.
ArslanAltaf
2 weeks agoArslanAltaf
1 week, 6 days agoogi33
4 days, 16 hours agoPoke90
1 year, 1 month agoEltelwany
1 year, 1 month ago