How many unique?
But what if we want to calculate the number of unique site visitors? Sounds like a combination of selecting unique and then counting...
Yes, that's the point! To calculate the number of unique observations over a certain column use COUNT(DISTINCT( ... ))
statement. For example,
12SELECT COUNT(DISTINCT(user_id)) FROM visitors
This query will return a single value - the number of unique user_id
in the visitors
table.
Swipe to start coding
Count the number of different cars model
s in the audi_cars
table.
Solution
Merci pour vos commentaires !
single
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Awesome!
Completion rate improved to 2.63
How many unique?
Glissez pour afficher le menu
But what if we want to calculate the number of unique site visitors? Sounds like a combination of selecting unique and then counting...
Yes, that's the point! To calculate the number of unique observations over a certain column use COUNT(DISTINCT( ... ))
statement. For example,
12SELECT COUNT(DISTINCT(user_id)) FROM visitors
This query will return a single value - the number of unique user_id
in the visitors
table.
Swipe to start coding
Count the number of different cars model
s in the audi_cars
table.
Solution
Merci pour vos commentaires !
Awesome!
Completion rate improved to 2.63single