> >- have only one highest age (since there is an "eldest") > >Looking at the output this would only be true for ages 9, 2 and 2 > > Yes but 6,6,1 doesn't necessarily mean that the two children > aged 6 are twins - one could have been born in January and one > in December in the same year and hence have the same age (in > years) on December 31st - but the one born in January would > clearly be the eldest.
It's getting off-topic a bit ;-) - Boris might have children with more than one woman! ;-) - It's not very common that the same mother has had two children (not twins) within 12 months. Besides, only during a limited timeframe the ages in years of two such children would be the same. - Boris and Vladimir are mathematicians. If they start using ages as a whole number of years than it is likely that they forget the real concept of age and just use integer numbers instead. - If "eldest" cannot be used anymore, one needs to know how many windows the building has... A more on-topic issue: How can one list the ages sorted and thus use a DISTINCT to filter permutations? How can one query "there is an eldest"? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]