amitverma

 Profile Answers by amitverma 

• Sep 25th, 2008

 

Sub queries in MySQL handled nested way, You can see the example and understand yourself -

SELECT name, headofstate, population FROM Country WHERE population=(SELECT MAX(population) FROM Country);

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 30th, 2010

 

Subqueries in MySQL are handled in the following way.

For e.g
Schema for sailor table :
Sid:int(2) PK
SName:varchar(15)
Rating:int(3)
Age int(3)

If you want to select name and age of oldest sailor, its query will  be as follows

SELECT Sname,Age FROM sailors WHERE Age IN (SELECT max(Age) FROM sailors)