MySQL Forums
Forum List  »  Views

Re: Help with conceptualizing a query
Posted by: Peter Brawley
Date: November 17, 2013 12:10AM

Is this what you mean?

First phase ...
select ...
from ...
where phase=(select min(phasenumber) where projectid=...)

Latest ...
select ...
from ...
where phase=(select max(phasenumber) where projectid=...)

Probably not a good idea to store such results in a column, since inserts & updates could change the result at any time.

Options: ReplyQuote

Written By
November 14, 2013 03:24PM
Re: Help with conceptualizing a query
November 17, 2013 12:10AM
November 18, 2013 01:20PM
November 18, 2013 09:50PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.