| List: | General Discussion | « Previous MessageNext Message » | |
| From: | James Lockie | Date: | May 25 2007 7:11pm |
| Subject: | do I need 2 selects? | ||
| View as plain text | |||
Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'? Is there a way to do it in one select?
| Thread | ||
|---|---|---|
| • do I need 2 selects? | James Lockie | 25 May |
| • Re: do I need 2 selects? | Joerg Bruehe | 25 May |
| • Re: do I need 2 selects? | Baron Schwartz | 26 May |
| • Re: do I need 2 selects? | Reinhardt Christiansen | 26 May |
| • Re: do I need 2 selects? | James Lockie | 25 May |
