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
.
Рішення
Дякуємо за ваш відгук!
single
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Awesome!
Completion rate improved to 4.17
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
.
Рішення
Дякуємо за ваш відгук!
Awesome!
Completion rate improved to 4.17single