MySQL Forums
Forum List  »  PHP

Re: how I filter car quote per price min max... in other words how complex calc works
Posted by: Rick James
Date: March 03, 2014 06:23PM

Please define "final price". Is the price changing? Are there multiple rows, each with a price and timestamp? If so, then we need to find the price in the row with the MAX(timestamp)?

That is solved either with (if you need one item)
ORDER BY timestamp DESC LIMIT 1
or by "groupwise max", which is a more complex query.

Options: ReplyQuote


Subject
Written By
Posted
Re: how I filter car quote per price min max... in other words how complex calc works
March 03, 2014 06:23PM


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.