CODEWITHSUNDEEP
mysqlsql
user3521314
user3521314

Reputation: 504

How can I use multiple subqueries in a WHERE

Just starting to learn SQL and I can't find the answer after a million google searches.

SELECT name, population FROM world
WHERE population > (SELECT population FROM world 
WHERE name = 'Canada');
WHERE population < (SELECT population FROM world
WHERE name = 'Poland');

I know you could use "Joins" or something else like that but using subqueries how would I do this? Basically, I'm looking for populations that are greater than Canada's but less than Poland's.

Upvotes: 0

Views: 31

Answers (4)

The_DemoCorgin
The_DemoCorgin

Reputation: 744

You almost have it. Just need an AND instead of a semi-colon. 

SELECT name, population FROM world
WHERE population > (SELECT population FROM world WHERE name = 'Canada')
AND
WHERE population < (SELECT population FROM world WHERE name = 'Poland');

:)

Upvotes: 1

Carter
Carter

Reputation: 342

Read up on basic syntax.

Try

SELECT name, population FROM world WHERE population > (SELECT population FROM world WHERE name = 'Canada'); AND population < (SELECT population FROM world WHERE name = 'Poland');

Upvotes: 0

Victory
Victory

Reputation: 5890

Try using AND.

SELECT name, population FROM world
WHERE population > (SELECT population FROM world WHERE name = 'Canada')
AND population < (SELECT population FROM world WHERE name = 'Poland');

Upvotes: 0

VJ Hil
VJ Hil

Reputation: 904

SELECT name, population FROM world
WHERE population > (SELECT population FROM world 
WHERE name = 'Canada') AND 
population < (SELECT population FROM world
WHERE name = 'Poland');

Upvotes: 0

Related Questions