Mysql to find most popular

Databases
1

Hi Guys,

I have a col called “Telephone No”.

How would i find out the most popular number in the rows?

There is over 50 different telephone numbers in there.

2

Insufficient data.

3

Will a table structure do?

4

If those are column names, I personally never put spaces in column names. Use an underscore, at least. Or camelCase. Also, I wouldn’t use things like parenthesis or other special characters in column names, either. Nor reserved words (“date”, “UUID”, etc.)

In order to see which number is called the most, I think some kind of metric is in order. An int column that incrementally increases every time a number is called would be the simplest.

Not knowing the context of your site/app, or other information, it is difficult to answer.

5 
SELECT `Telephone No`
     , COUNT(*)
  FROM daTable
GROUP
    BY `Telephone No`
ORDER
    BY COUNT(*) DESC LIMIT 1
6

Deffo the SQL GURU!

THANK YOU AGAIN! :smiley: