posted 15 years ago
In a village there are five families and each family has 2 children each as shown in the table structure
Parents:
Id,father,mother
Children:
Id,pid,age
Question: Give the output of each of the following queries
Select p.father,p.mother from parents p,children c where
c.pid=p.id and(c.age=(select MAX(age) from children)) or (c.age=(select
MIN (age) from children))
options are:
a)throws an SQL error
b)returns 0 rows
c)returns all the rows
d)returns atleast 2 rows
what will be the answer?
i am unable to understand the question.can any one tell me the answer?
Thanks in advance