How to correctly select all unique BINARY values and sort them by number of occurrences?

K

khodos_dmitry2018-06-15 13:58:03

MySQL

khodos_dmitry, 2018-06-15 13:58:03

SELECT BINARY `name` as bname, COUNT(*) FROM `param` GROUP BY BINARY `name` ORDER BY COUNT(*) DESC

such a request is taking too long. Is there a way to speed it up?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

@

@nixbox2019-11-14 18:59:05

G

GaserV2017-06-24 02:43:34

D

des1roer2017-07-02 18:55:47

N

Nikolai Ignatiev2015-07-30 16:17:27

W

Didn't find what you were looking for?