List:General Discussion« Previous MessageNext Message »
From:Adam Bishop Date:January 22 2007 6:32am
Subject:SQL Query Question
View as plain text  
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.

 

Thanks,

 

Adam Bishop


Thread
SQL Query QuestionAdam Bishop22 Jan
  • Re: SQL Query QuestionDan Nelson22 Jan
    • RE: SQL Query QuestionAdam Bishop22 Jan