The Gateway to Computer Science Excellence
+1 vote
135 views

in Databases by Active (1.9k points) | 135 views
+2
0 should be the answer
0
I am getting 4. Select* from professor P1 where P1.rating > ALL( 8.5,8.5) ,<-- that's why I am getting 4.

please explain how 0?

This a correlated query, therefore each tuple of P2 will be compared with P3. And for innermost query output should 5 for 8.5. What did I miss?
0

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,370 answers
198,506 comments
105,275 users