Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
semijoin
/
semiJoinSameTable15.sql
blob: 2249268201cadbbe017b4afb8150acf81202b079 [
file
] [
log
] [
blame
]
set
`
planner
.
enable_semijoin
`
=
true
;
select
orders
.
o_totalprice
from
orders
where
orders
.
o_totalprice
in
(
select
orders
.
o_totalprice
from
orders
)
order
by
orders
.
o_totalprice limit
10
;
reset
`
planner
.
enable_semijoin
`;