MySQL_Narb Posted August 5, 2012 Share Posted August 5, 2012 http://www.sqlzoo.net/1a.htm I did: SELECT name,region FROM bbc WHERE region IN ((SELECT region FROM bbc WHERE name LIKE '%India%'), (SELECT region FROM bbc WHERE name LIKE '%Iran%')) Was this really the correct query? It says it is, but it just feels like there's a more simplified way. Quote Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/ Share on other sites More sharing options...
MySQL_Narb Posted August 5, 2012 Author Share Posted August 5, 2012 Ignore the above post please. I would like for anyone that can solve this problem to help me out if they can: SELECT name,population,region FROM bbc b WHERE 25000000 > ALL(SELECT population FROM bbc x WHERE b.region=x.region) Is currently what I have, for 3b: http://www.sqlzoo.net/1a.htm Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/#findComment-1366920 Share on other sites More sharing options...
fenway Posted August 5, 2012 Share Posted August 5, 2012 This sounds like homework -- what are you actually trying to do? Quote Link to comment https://forums.phpfreaks.com/topic/266699-select-statement/#findComment-1366965 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.