Bug #62718 Request : WhereMin, WhereMax
Submitted: 13 Oct 2011 13:49
Reporter: David Merrick Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.5.16 OS:Windows (XP SP3 Pro)
Assigned to: CPU Architecture:Any

[13 Oct 2011 13:49] David Merrick 
Description:
Feature Request:
Often a value is required for when something is minimal or maximal, for example we may wish to show against each product its cheapest supplier and price thereof. In Sql this could theoretically look something like,
Select Product,Min(Price) As PriceOfCheapest,IfMin(Price,Supplier) As SupplierOfCheapest
From Products
Group By Product

Currently (unless i've missed something!) complex workarounds are required, and yet this is such a simple, commonly-required feature, which, whilst being a "feature" would be setting the trend and a good recommendation point.

d

How to repeat:
See above :)
[14 Oct 2011 13:20] Valeriy Kravchuk 
This is a new feature request, not a bug.