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:

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

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Select Column

解答