[EMAIL PROTECTED] (Bob Barrows) wrote in message news:<[EMAIL PROTECTED]>... > Do you care about ties? What if Ingrid, 38 yrs old, worked at IBM? > Would you want to show both Ingrid and Maria? If so, this will work: > > Select Name From People t1 Inner Join > (Select Company, Max(Age) As Oldest FROM People > Group By Company) t2 > ON t1.Company = t2.Company AND t1.Age = t2.Oldest >
Thanks a lot, the query work perfect! I dont care about ties... this is just the query I need... Bye ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
