Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2010
    Nowhere, anywhere.

    Red face Unanswered: mSQL, this query would do...?

    Ok, I'm not sure this is in the right forum, because I'm new here, so please if this is in the wrong one, please don't hate me.

    Secondly, I feel a very silly (and scared) asking this, but I'm having a complete mental mind blank. What would this query do?

    Select state_represented
    From prime_minister
    Group by state_represented
    Having count(*) >= all
    (Select count(*)
    From prime_minister
    Group by state_represented)

    (I have the basic gist of it, but I'm not convinced that I have it correct. By the way, this isn't for any assignment or anything like that. It's a revision question which I just can't seem to wrap my head around.)

    Also, to help, is there any other information you would need? (Sorry, if I sound like a complete newb... I am.)
    Last edited by Light Devil; 06-11-10 at 22:26. Reason: Spelling

Tags for this Thread

Posting Permissions

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