Conteúdo do Curso
TEST SQL COURSE E2E
TEST SQL COURSE E2E
Retrieving Distinct Rows
Note that the SELECT statement returns all rows in a given column. Nevertheless, what if we don't need all the values from a column (because they can be duplicated), and we only need unique values? For such cases, it is convenient to use the keyword DISTINCT. Moreover, this keyword is used immediately before the column names. Let's look at an example.
SELECT DISTINCT region FROM country;
Swipe to show code editor
You have to retrieve distinct (unique) continent values.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Retrieving Distinct Rows
Note that the SELECT statement returns all rows in a given column. Nevertheless, what if we don't need all the values from a column (because they can be duplicated), and we only need unique values? For such cases, it is convenient to use the keyword DISTINCT. Moreover, this keyword is used immediately before the column names. Let's look at an example.
SELECT DISTINCT region FROM country;
Swipe to show code editor
You have to retrieve distinct (unique) continent values.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Retrieving Distinct Rows
Note that the SELECT statement returns all rows in a given column. Nevertheless, what if we don't need all the values from a column (because they can be duplicated), and we only need unique values? For such cases, it is convenient to use the keyword DISTINCT. Moreover, this keyword is used immediately before the column names. Let's look at an example.
SELECT DISTINCT region FROM country;
Swipe to show code editor
You have to retrieve distinct (unique) continent values.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Note that the SELECT statement returns all rows in a given column. Nevertheless, what if we don't need all the values from a column (because they can be duplicated), and we only need unique values? For such cases, it is convenient to use the keyword DISTINCT. Moreover, this keyword is used immediately before the column names. Let's look at an example.
SELECT DISTINCT region FROM country;
Swipe to show code editor
You have to retrieve distinct (unique) continent values.
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo