PPT Slide

Subquery Processing

SELECT *

FROM t1

WHERE t1.a > ( SELECT AVG(t2.b)

FROM t2

WHERE t2.c = t1.d )

t1

t1

t2

t2

C

answers

t1.d

sum,count

Previous slide

Back to first slide

View graphic version