MySQL按X顺序然后分组按Y然后按字母顺序排列Z.-MySQLOrderByXthenGroupByYthenArrangeZAlphabatically

0  

SELECT Item, Min(Price), Other_Columns FROM table GROUP BY Item ORDER BY Item

IF you want the Id, color, and model that belong to the min price, things get complicated. You could use something like:

如果你想要属于最低价格的Id,颜色和模型,事情会变得复杂。你可以使用类似的东西:

SELECT * FROM `table` WHERE id IN 
    (SELECT MIN(id) FROM `table` T1 WHERE Price=
        (SELECT MIN(Price) FROM `table` T2 WHERE T1.Item=T2.Item) 
     GROUP BY Item, Price)

Basically what you do is:first establish the min price per Item. Than find all the first id's from every Item with that price. Than select all the columns from all the records with those Id's. Probably it can be done simpler, but this is easiest to understand.

基本上你所做的是:首先确定每件物品的最低价格。然后找到具有该价格的每个物品的所有第一个ID。然后选择具有这些Id的所有记录中的所有列。可能它可以更简单,但这是最容易理解的。

Iam not sure f that is what you want, since your question was not very specific/clear (hence all the negative votes). But I sort of came to believe it is.

我不确定那是你想要的,因为你的问题不是很具体/清楚(因此所有的反对票)。但我有点开始相信它。