SQL Left & Right Join
LEFT JOIN returns all records from the left table and matching records from the right table. For records with no matching, it completes the fields with NULL. For example, let's select all albums joined with songs ids with LEFT JOIN:
123SELECT albums.title, songs.id FROM albums LEFT JOIN songs ON songs.album_id = albums.id
On the diagram for this query, we can see that not all albums have songs in a table, so absent fields are autocompleted with NULL. Similarly, we can see in the result query: some albums have empty id's for the songs, because there are no songs for these albums.
Swipe to start coding
Do the joining for tables albums and songs using INNER JOIN, RIGHT JOIN, FULL JOIN, and check the difference. Then, find the number of songs for each album (even if there are no songs in it). Think about which JOIN you can use here. Order everything by albums title.
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 5.88SQL Left & Right Join
Sveip for å vise menyen
LEFT JOIN returns all records from the left table and matching records from the right table. For records with no matching, it completes the fields with NULL. For example, let's select all albums joined with songs ids with LEFT JOIN:
123SELECT albums.title, songs.id FROM albums LEFT JOIN songs ON songs.album_id = albums.id
On the diagram for this query, we can see that not all albums have songs in a table, so absent fields are autocompleted with NULL. Similarly, we can see in the result query: some albums have empty id's for the songs, because there are no songs for these albums.
Swipe to start coding
Do the joining for tables albums and songs using INNER JOIN, RIGHT JOIN, FULL JOIN, and check the difference. Then, find the number of songs for each album (even if there are no songs in it). Think about which JOIN you can use here. Order everything by albums title.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
Awesome!
Completion rate improved to 5.88single
