Returning Top N elements

vapor · #1 (**permalink**) 05-19-09, 09:16

Hi,

I have a db that stores searches. I want to return top N searches.
Currently it stores like...

Keyword
--------
A
A
C
B
C
A

I want to return it like...

Top
----
A
C
B

Can you please help me with the query?
Thanks.

r937 · #2 (**permalink**) 05-19-09, 09:24

Code:

SELECT keyword AS Top
  FROM daTable
GROUP
    BY keyword
ORDER
    BY COUNT(*) DESC LIMIT N

vapor · #3 (**permalink**) 05-19-09, 09:26

Yummy!
Thanks.

vapor · #4 (**permalink**) 05-20-09, 04:06

A little change...

Instead of storing each keyword, I am going to check if keyword is already in table, if yes then increase it's "repeat" column by 1 or else add it to db with "repeat" as 1.

Is it possible with MySQL or do I have to do it in lang?

r937 · #5 (**permalink**) 05-20-09, 07:11

yes, it's possible

use INSERT... ON DUPLICATE KEY UPDATE ...

Internet Services

Web Development

Digital Marketing

Consumer Tech