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 models in the audi_cars table.
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 2.63How many unique?
Sveip for å vise menyen
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 models in the audi_cars table.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
Awesome!
Completion rate improved to 2.63single
