Contenido del Curso
SQL Basics
SQL Basics
Unique values from column
In real life, you may work with big tables containing thousands of rows and lots of columns. For example, you may have a database with all the users who have visited your site, and you want to know all the countries that attended your site.
In SQL, to extract unique values from the column use the DISTINCT statement. For example, to extract unique countries from the table visitors use:
SELECT DISTINCT(country) FROM visitors
Swipe to show code editor
From the audi_cars table extract all the unique models of cars.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Unique values from column
In real life, you may work with big tables containing thousands of rows and lots of columns. For example, you may have a database with all the users who have visited your site, and you want to know all the countries that attended your site.
In SQL, to extract unique values from the column use the DISTINCT statement. For example, to extract unique countries from the table visitors use:
SELECT DISTINCT(country) FROM visitors
Swipe to show code editor
From the audi_cars table extract all the unique models of cars.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Unique values from column
In real life, you may work with big tables containing thousands of rows and lots of columns. For example, you may have a database with all the users who have visited your site, and you want to know all the countries that attended your site.
In SQL, to extract unique values from the column use the DISTINCT statement. For example, to extract unique countries from the table visitors use:
SELECT DISTINCT(country) FROM visitors
Swipe to show code editor
From the audi_cars table extract all the unique models of cars.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
In real life, you may work with big tables containing thousands of rows and lots of columns. For example, you may have a database with all the users who have visited your site, and you want to know all the countries that attended your site.
In SQL, to extract unique values from the column use the DISTINCT statement. For example, to extract unique countries from the table visitors use:
SELECT DISTINCT(country) FROM visitors
Swipe to show code editor
From the audi_cars table extract all the unique models of cars.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones