Write a query to select all teams that won either 1, 3, 5 or 7 games.

  • SELECT team_name FROM team WHERE team_won IN (1, 3, 5, 7);

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What is the basic MySQL architecture?

How can we get the number of rows affected by query?

Write a query to count the number of rows of a table in MySQL.

What is the difference between BLOB and TEXT?

What are the column comparisons operators?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges