我想根据门店数量选择具有不同门店位置的行，示例如下所示：
id | item_name | number_of_store| store_location|+----+---------+-------------------+-------------+| 3 | margarine | 2 | QLD || 4 | margarine | 2 | NSW || 5 | wine | 3 | QLD || 6 | wine | 3 | NSW || 7 | wine | 3 | NSW || 8 | laptop | 1 | QLD |+----+---------+-------------------+-------------+
预期结果如下所示：
id | item_name | number_of_store| store_location|+----+---------+-------------------+-------------+| 3 | margarine | 2 | QLD || 4 | margarine | 2 | NSW || 5 | wine | 3 | QLD || 6 | wine | 3 | NSW || 8 | laptop | 1 | QLD |+----+---------+-------------------+-------------+
我不在乎返回哪个id列值。需要什么样的sql？
1条答案
按热度按时间k5ifujac1#
你可以用
GROUP BY:否则你需要
ANY_VALUE或聚合函数，如MIN:db-fiddle.com演示