MySQL Forums
Forum List  »  Newbie

Re: Mysql Nested sub query
Posted by: Peter Brawley
Date: April 20, 2022 12:03AM

Yikes, 5.0 reached end-of-life more than twelve years ago. The oldest MySQL version I have access to is 5.7. Good chance what I test in 5.7 will fail in 5.0.

cost and cost_price are usd_price * exchange_rate * quantity?

What weights are to be used for the weighted averages?

What is desired when there are multiple transactions per part_code on the last date for which there is a transaction?

And for the sample dataset provided, what are the expected results for latest_grv_price_prior_to_the_specified_date, weighted_average_cost_up_to_specified_date, maximum_cost_price_up_to_specified_date ?



Edited 1 time(s). Last edit at 04/20/2022 12:06AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
April 19, 2022 10:56PM
April 19, 2022 11:14PM
April 19, 2022 11:15PM
April 19, 2022 11:24PM
April 19, 2022 11:34PM
Re: Mysql Nested sub query
April 20, 2022 12:03AM
April 20, 2022 12:41AM
April 20, 2022 09:57AM
April 20, 2022 11:23PM
April 21, 2022 04:04AM
April 21, 2022 07:52AM


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.