Results 1 to 4 of 4

Thread: Help me

  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Unanswered: Help me

    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?
    What? Can't move without me?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

  3. #3
    Join Date
    Mar 2004
    Posts
    17
    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.
    What? Can't move without me?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •