Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
subqueries
/
exists_not_exists
/
q10.sql
blob: 8c62d673674daf12c81d06fca470baf581a62f07 [
file
] [
log
] [
blame
]
-- scalar aggregate in not exists returns NULL value
-- with correlation to outer table
select
*
from
t1
where
not
exists
(
select
max
(
a2
)
+100
from
t2
where
a2
>
10000
)
order
by
1
;