most frequently occured word in a database table column in MYSQL

Question

I have a database table in MySql as follows :

  myTable
      col1 integer
      col2 integer
      col3 text

There are many more columns in the table, but for my question, these three matter.

What I want to do is that, I want to print the sum of column 1 and column 2. With this, I want to print the string from col3 which has maximum occurrence. If there are more strings with the same occurrence, I want to print which comes first alphabetically. How is that possible in MySql ? Is it even possible in single query? (This can be marked as a homework question. I am trying to figure out the solution but with my current knowledge base I am not able to do it. Some pointers on how it can be solved or some hints will prove helpful.

Can I have your marks when I have done your homework. Perhaps re-read the lecture notes and/or manual page for select — Ed Heal, Nov 01 '14 at 10:44
select sum(col1) , sum (col2) ,col3 from myTable group by col3; — user3686864, Nov 01 '14 at 10:50
The above query gives me the sum for various entries in col3 — user3686864, Nov 01 '14 at 10:53
Possible duplicate of [How to find most popular word occurrences in MySQL?](https://stackoverflow.com/questions/32761188/how-to-find-most-popular-word-occurrences-in-mysql) — Moradnejad, Feb 08 '19 at 09:08

score 1 · Answer 1 · answered Nov 01 '14 at 10:50

Since you are asking for homework support, I'm not going to provide the query itself.

That said, you should look into GROUP BY Functions to calculate the number of occurrences for a word. In addition, look into ORDER BY to learn how to sort your results. Adding the value of different columns is a simple expression which you can just write in the SELECT statement.

most frequently occured word in a database table column in MYSQL

1 Answers1