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


Subject
Views
Written By
Posted
4932
November 14, 2013 03:24PM
Re: Help with conceptualizing a query
1569
November 17, 2013 12:10AM
1600
November 18, 2013 01:20PM
1699
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.