MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Select (future stored procedures) for price comparison, bringing only the lowest total of the list.
Posted by: Peter Brawley
Date: September 24, 2014 11:23AM

> what needs to appear to the user is the name of the supplier and the total value of less list.

Surely you need more than that: for each product in the user's list, you need the id, lowest price, and vendor supplying that lowest price, then you assemble that list and sum it. Does that give you the hint you need to write the query?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Select (future stored procedures) for price comparison, bringing only the lowest total of the list.
2107
Adriana Araujo Drika
September 24, 2014 10:43AM
Re: Select (future stored procedures) for price comparison, bringing only the lowest total of the list.
1087
Peter Brawley
September 24, 2014 11:23AM
Re: Select (future stored procedures) for price comparison, bringing only the lowest total of the list.
1057
Adriana Araujo Drika
September 24, 2014 12:03PM


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.