Jump to content

SunD

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

SunD's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. OOOOOOppppppppppppppsssssssss!!!!!! ;D I forgot the top 10!!!!! Tables: [b]tmp_Location (LocationID, Location) tmp_User (UserID, UserName, LocationID)[/b] This is the sql statement that would produce the Location and the number of Users on that Location. [b]Select Top 10 b.Location, Count(b.Location) As LocationCount From tmp_User a Left Outer Join tmp_Location b On a.LocationID = b.LocationID Group By b.Location Order By LocationCount Desc[/b] Figure it out.
  2. Tables: [b]tmp_Location (LocationID, Location) tmp_User (UserID, UserName, LocationID)[/b] This is the sql statement that would produce the Location and the number of Users on that Location. [b]Select b.Location, Count(b.Location) As LocationCount From tmp_User a Left Outer Join tmp_Location b On a.LocationID = b.LocationID Group By b.Location Order By LocationCount Desc[/b] Figure it out.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.