Help me

Deviruchi · #1 (**permalink**) 05-27-04, 05:20

I have this mysql code that gets the value of the field that contains most number of results in the database.

Code:

select value, count(*) as selectedvalue_count from one group by 
selectedvalue order by selectedvalue_count desc

this works fine but it doesn't take into considerations if there are two or more values having the same number of records in the database. any help?

Pat Phelan · #2 (**permalink**) 06-02-04, 09:22

I'll byte. What would you like it to do when there are two values with the maximum number of occurances? Show both, pick one, panic, or something else?

-PatP

Deviruchi · #3 (**permalink**) 06-02-04, 09:49

maybe i should panic, attack dbforum, then delete the thread entitled "Yak Corral". hey, don't take this one too seriously.

already solved the problem, thanks anyway.

Pat Phelan · #4 (**permalink**) 06-02-04, 12:10

Quote:

Originally Posted by Deviruchi

maybe i should panic, attack dbforum, then delete the thread entitled "Yak Corral". hey, don't take this one too seriously.

already solved the problem, thanks anyway.

Huh ?!?! Where'd that one come from? Did I miss another meeting?

Oh well, as long as you've got an answer that works, I'm Ok with that!

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech