• Home
• com.facebook.presto
• presto-product-tests
• 0.288
• source code
• except.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql-tests.testcases.set_operation.except.sql Maven / Gradle / Ivy

-- database: presto; tables: nation, workers; groups: set_operation;
-- delimiter: |; ignoreOrder: true;
--! name: except_union_intersect
SELECT n_name FROM nation WHERE n_nationkey = 17
EXCEPT
SELECT n_name FROM nation WHERE n_regionkey = 2
UNION
(SELECT n_name FROM nation WHERE n_regionkey = 2
INTERSECT
SELECT n_name FROM nation WHERE n_nationkey > 15)
--!
CHINA|
VIETNAM|
PERU|
--! name: except_union_all_intersect
SELECT n_name FROM nation WHERE n_nationkey = 17
EXCEPT
SELECT n_name FROM nation WHERE n_regionkey = 2
UNION ALL
(SELECT n_name FROM nation WHERE n_regionkey = 2
INTERSECT
SELECT n_name FROM nation WHERE n_nationkey > 15)
--!
CHINA|
VIETNAM|
PERU|
--! name: except_null
SELECT id_employee FROM workers
EXCEPT
SELECT department FROM workers where department IS NOT NULL
--!
null|
3|
6|
10|
1|