Hello all -- I'm sorry if this is off topic, but does anybody know of a way to find the most common entry in a database using an SQL query? I'm using MySQL to cache search engine terms and want to find the 5 most common terms .... I can do it in perl pretty easily using a hash to store the counts of each value, but don't want to do it that way unless there is no way to do it in SQL. Thanks in advance
- MS Access Queries Sean Cooper
- MS Access Queries John Passaniti
- Re: MS Access Queries Brett W. McCoy
- Re: Most common anything in a database -- Ronald J Kimball
- Re: Most common anything in a database -- Tommy Wareing
