If I have a dataset as below:
Name, Age, Word
Bob, 13, bill
Joe, 13, oxo
Alex, 14, thing
Jim, 14, blob
Phil, 14, whatsit
Ben, 15, doodah
Rodney, 15, thingy
I want to select the first block where the age is equal, i.e. return in the
case of the above set, Bob and Joe, and with the same query if Bob and Joe
didn't exist, return Alex, Jim, and Phil.
In broken SQL, I want to "SELECT * FROM `table` WHERE 'Age'='Age 1st Row';".
I'm guessing this could be done with nested queries, but this is me
attempting to optimise a script from 3 queries to 1, so the gains by using
nested queries would be negligible.
I'm guessing that this isn't possible, but I thought asking some people that
know more than myself couldn't hurt.
Any assistance is appreciated.