• Home
• com.facebook.presto
• presto-product-tests
• 0.288
• source code
• intersect.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.intersect.sql Maven / Gradle / Ivy

-- database: presto; tables: nation, workers; groups: set_operation;
-- delimiter: |; ignoreOrder: true;
--! name: intersect_and_union
SELECT n_name FROM nation WHERE n_nationkey = 17 
INTERSECT 
SELECT n_name FROM nation WHERE n_regionkey = 1 
UNION 
SELECT n_name FROM nation WHERE n_regionkey = 2
--!
INDIA|
INDONESIA|
CHINA|
JAPAN|
VIETNAM|
PERU|
--! name: intersect_null
SELECT id_employee
FROM workers
INTERSECT
SELECT department
FROM workers
--!
null|
9|
4|
7|
2|
5|
8|