Unique values from multiple columns
But what if we want to know, for example, unique pairs 'country-city' of our site visitors? Surely, we can extract unique countries (like in the previous chapter) and unique cities. But then we have to connect each city to the country manually.
This task can be solved by the same DISTINCT, but this time with two columns. For example,
12SELECT DISTINCT(country), city FROM visitors
The
DISTINCTstatement will return all the unique combinations of columns you chose. Using parentheses is not mandatory, i.e. you for the example above you can writeDISTINCT country, city. But placing multiple columns withinDISTINCTparentheses will return only one column of all unique combinations in(country, city)format.
Swipe to start coding
Extract all unique combinations of model and transmission
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Unique values from multiple columns
But what if we want to know, for example, unique pairs 'country-city' of our site visitors? Surely, we can extract unique countries (like in the previous chapter) and unique cities. But then we have to connect each city to the country manually.
This task can be solved by the same DISTINCT, but this time with two columns. For example,
12SELECT DISTINCT(country), city FROM visitors
The
DISTINCTstatement will return all the unique combinations of columns you chose. Using parentheses is not mandatory, i.e. you for the example above you can writeDISTINCT country, city. But placing multiple columns withinDISTINCTparentheses will return only one column of all unique combinations in(country, city)format.
Swipe to start coding
Extract all unique combinations of model and transmission
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
single
Awesome!
Completion rate improved to 2.63Unique values from multiple columns
Veeg om het menu te tonen
But what if we want to know, for example, unique pairs 'country-city' of our site visitors? Surely, we can extract unique countries (like in the previous chapter) and unique cities. But then we have to connect each city to the country manually.
This task can be solved by the same DISTINCT, but this time with two columns. For example,
12SELECT DISTINCT(country), city FROM visitors
The
DISTINCTstatement will return all the unique combinations of columns you chose. Using parentheses is not mandatory, i.e. you for the example above you can writeDISTINCT country, city. But placing multiple columns withinDISTINCTparentheses will return only one column of all unique combinations in(country, city)format.
Swipe to start coding
Extract all unique combinations of model and transmission
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
