Зміст курсу

SQL Tutorial for Beginners

1. Database & Introduction to Syntax

2. SQL Aggregate Functions

3. Filtering Statements

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:


              1
            
SELECT title FROM songs

You can also choose two or more columns:


              1
            
SELECT title, singer FROM songs

Now you selected all records from the table, but only title and singer columns.

Завдання

Select info about album and year for all records from songs.

Завдання

Select info about album and year for all records from songs.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 1. Розділ 3

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:


              1
            
SELECT title FROM songs

You can also choose two or more columns:


              1
            
SELECT title, singer FROM songs

Now you selected all records from the table, but only title and singer columns.

Завдання

Select info about album and year for all records from songs.

Завдання

Select info about album and year for all records from songs.

Все було зрозуміло?

Секція 1. Розділ 3

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:


              1
            
SELECT title FROM songs

You can also choose two or more columns:


              1
            
SELECT title, singer FROM songs

Now you selected all records from the table, but only title and singer columns.

Завдання

Select info about album and year for all records from songs.

Завдання

Select info about album and year for all records from songs.

Все було зрозуміло?

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:


              1
            
SELECT title FROM songs

You can also choose two or more columns:


              1
            
SELECT title, singer FROM songs

Now you selected all records from the table, but only title and singer columns.

Завдання

Select info about album and year for all records from songs.

Секція 1. Розділ 3