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.
1SELECT DISTINCT region FROM country;
Swipe to start coding
You have to retrieve distinct (unique) continent values.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Awesome!
Completion rate improved to 16.67Retrieving Distinct Rows
Desliza para mostrar el menú
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.
1SELECT DISTINCT region FROM country;
Swipe to start coding
You have to retrieve distinct (unique) continent values.
Solución
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Awesome!
Completion rate improved to 16.67single
