MySQL Count all rows and unique rows

Question

I am trying to do exactly what the title says, get the total number of records and the number of records that are unique in a certain column.

What I tried so far

SELECT COUNT(ip) AS visits, ip FROM tracker WHERE time BETWEEN ? AND ? GROUP BY ip

SELECT DISTINCT COUNT(ip) AS visits, ip FROM tracker WHERE time BETWEEN ? AND ?

SELECT DCOUNT(ip) AS visits, DISTINCT(ip) AS `unique` FROM tracker WHERE time BETWEEN ? AND ?

However none of these brought me pleasant feelings.. How can I do this?

User2010101 · Accepted Answer · 2014-09-24 23:51:44Z

1

I believe that what you need is this

SELECT COUNT(DISTINCT)

So it should be :

SELECT COUNT(DISTINCT ip) AS visits FROM tracker;

answered Sep 24, 2014 at 23:51

User2010101

927 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

php_nub_qq Over a year ago

Now I'm left to wonder if this is efficient or not :D. Thanks!

User2010101 Over a year ago

I have to say that I'm wondering the same. But I've to add that a where statement will help you to increase the performance if we talk about a specific period of time.

Collectives™ on Stack Overflow

MySQL Count all rows and unique rows

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related