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.
Oplossing
Bedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Vat dit hoofdstuk samen
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 4.17SQL Select Column
Veeg om het menu te tonen
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
Awesome!
Completion rate improved to 4.17single
