GROUP By doubt

Results 1 to 2 of 2

Thread: GROUP By doubt

  1. #1
    Join Date
    Dec 1969

    Default GROUP By doubt

    Hello! I have question to make you... Ive got a table with tree columns, one of them is user_id, that as the user id number, another one is prob, that as the probality of the user to be of a class, and I have a column named classe, that is the class of the user_id. Now, I want group the user_id (the are multiples regists for the same user, one for each class) and return the max prob, and the class that max prob is linked to. How can I do That?

  2. #2
    Join Date
    Dec 1969

    Default RE: GROUP By doubt

    select userid , max(prob) from tblUserProbability <BR>group by userid<BR><BR>

Posting Permissions

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