SQL Select Column
You can retrieve not all the data, but only some columns. For this, you should specify column name, for example, singer or title.
This query returns all the data containing in the title column:
1SELECT title FROM songs
You can also choose two or more columns:
1SELECT title, singer FROM songs
Now you selected all records from the table, but only title and singer columns.
Swipe to start coding
Select info about album and year for all records from songs.
Ratkaisu
Kiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Tiivistä tämä luku
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 4.17SQL Select Column
Pyyhkäise näyttääksesi valikon
You can retrieve not all the data, but only some columns. For this, you should specify column name, for example, singer or title.
This query returns all the data containing in the title column:
1SELECT title FROM songs
You can also choose two or more columns:
1SELECT title, singer FROM songs
Now you selected all records from the table, but only title and singer columns.
Swipe to start coding
Select info about album and year for all records from songs.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Awesome!
Completion rate improved to 4.17single
