How would you write a query to select all teams that won either 3, 6, 9 or 12 games

Untitled › Forums › Assignment Help › How would you write a query to select all teams that won either 3, 6, 9 or 12 games

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 28, 2012 at 4:32 am #7166
    Aakanksha
    Participant

    How would you write a query to select all teams that won either 3, 6, 9 or 12 games?

    August 28, 2012 at 4:36 am #11858
    Aakanksha
    Participant

    SELECT teamname FROM tablename WHERE teamwon IN (3, 6, 9, 12)

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.