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:
12SELECT DISTINCT(country) FROM visitors
Swipe to start coding
From the audi_cars table extract all the unique models of cars.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Unique 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:
12SELECT DISTINCT(country) FROM visitors
Swipe to start coding
From the audi_cars table extract all the unique models of cars.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
single
Awesome!
Completion rate improved to 2.63Unique values from column
Stryg for at vise menuen
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:
12SELECT DISTINCT(country) FROM visitors
Swipe to start coding
From the audi_cars table extract all the unique models of cars.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
