MYSQL Count(Distinct) Group By

init3 Published at Dev

init3

This select keeps timing out:

SELECT COUNT(DISTINCT `invoices`) 
FROM `data` 
WHERE date BETWEEN '2013-07-01' AND '2014-06-30' 
GROUP BY `store`

I have made indexes on invoices, date, store and invoices, store, date. Any help is appreciated.

Marcx

try

SELECT `store`, COUNT(*) FROM 
   (SELECT `store`, `invoices`
          FROM `data` 
         WHERE date BETWEEN '2013-07-01' AND '2014-06-30' 
       GROUP BY `store`, `invoices`
   ) tbl
GROUP BY `store`

Here's a fiddle, without the date column and check...

http://sqlfiddle.com/#!9/fb83c/5/0

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-29

Comments

0 comments

From Dev

MySQL: GROUP BY

From Dev

GROUP BY on MySQL

From Dev

CountDistinct() based on few columns

From Dev

Skew Data with countDistinct

From Dev

MYSQL Group by and Group Concat issue

From Dev

MySQL group by affecting other group

From Dev

R Count and CountDistinct elements of a list

From Dev

null value and countDistinct with spark dataframe

From Dev

How to use countDistinct in Scala with Spark?

From Dev

CountDistinct based on a condition in spark scala

From Dev

MySQL, last in a group (again)

From Dev

GROUP BY in MySQL query

From Dev

MySQL: result of GROUP BY into columns

From Dev

MySQL GROUP BY query

From Dev

MYSQL - Group by and Order By

From Dev

MySql GROUP BY Max Date

From Dev

MySQL - Using desc on Group by

From Mysql

MySQL GROUP BY if condition

From Dev

MySQL GROUP by or using PHP?

From Dev

How to sum and group MySQL?

From Dev

Ignore MySQL Group By value

From Dev

Issue with group by clause in mysql

From Mysql

Mysql Group By age by range

From Mysql

MYSQL INNER JOIN AND GROUP BY

From Dev

MySQL subquery for group by fields

From Dev

MYSQL: Group By regex pattern

From Mysql

Group conca in mysql

From Dev

MYSQL :GROUP BY WITH ROLLUP ERROR

From Dev

mySQL: CASE, GROUP and ORDER By

From Dev

MySQL filter by values in a group

Related Related

Article