Kueri dengan UNION dan INTERSECT

Pengambilan Keputusan Berbasis Data dengan SQL

Tim Verdonck

Professor Statistics and Data Science

UNION

Pengambilan Keputusan Berbasis Data dengan SQL

Contoh - UNION

SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE renting_price > 2.8
UNION
SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE genre = 'Action & Adventure';
Pengambilan Keputusan Berbasis Data dengan SQL
SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE renting_price > 2.8
UNION
SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE genre = 'Action & Adventure';

| title      | genre              | renting_price |
|------------|--------------------|---------------|
|Fool's Gold | Action & Adventure | 2.69          |
|Astro Boy   | Action & Adventure | 2.89          |
|Fair Game   | Drama              | 2.89          |
Pengambilan Keputusan Berbasis Data dengan SQL

INTERSECT

Pengambilan Keputusan Berbasis Data dengan SQL

Contoh - INTERSECT

SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE renting_price > 2.8
INTERSECT
SELECT title, 
       genre, 
       renting_price
FROM movies
WHERE genre = 'Action & Adventure';

| title     | genre              | renting_price |
|-----------|--------------------|---------------|
| Astro Boy | Action & Adventure | 2.89          |
Pengambilan Keputusan Berbasis Data dengan SQL

Ayo berlatih!

Pengambilan Keputusan Berbasis Data dengan SQL

Preparing Video For Download...