SQL Full Outer Join
Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:
All uncompleted fields got the value NULL.
Swipe to start coding
For each singer, find the most expensive (price
) song and the newest (year
) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming
, songs.price
with price
alias, and albums.year
with year
alias values.
Soluzione
Grazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 5.88
SQL Full Outer Join
Scorri per mostrare il menu
Let's explore FULL OUTER JOIN: it does joining for a union of records of table1 and table2:
All uncompleted fields got the value NULL.
Swipe to start coding
For each singer, find the most expensive (price
) song and the newest (year
) album. Use FULL OUTER JOIN to see what's the result is. You should show singers.naming
, songs.price
with price
alias, and albums.year
with year
alias values.
Soluzione
Grazie per i tuoi commenti!
Awesome!
Completion rate improved to 5.88single