以下SQL,查询到的结果 min_price 和 url 是对的
但是与其相对的ID却不是最小值记录的IDselect
min(price) as min_price
,url
,id
from
ware
where
query_key = 'kakaku'
and price>0
group by url
查询结果如下min_price,url, ID
115500, 'http://kakaku.com/item/00490111141/', 10794
64800, 'http://kakaku.com/item/K0000080324/', 10793
82000, 'http://kakaku.com/item/K0000080327/', 11319请问如何解决
但是与其相对的ID却不是最小值记录的IDselect
min(price) as min_price
,url
,id
from
ware
where
query_key = 'kakaku'
and price>0
group by url
查询结果如下min_price,url, ID
115500, 'http://kakaku.com/item/00490111141/', 10794
64800, 'http://kakaku.com/item/K0000080324/', 10793
82000, 'http://kakaku.com/item/K0000080327/', 11319请问如何解决
select price min_price,url,id from ware t1 where not exists(
select 1 from ware where url=t1.url and price<t1.price);
[征集]分组取最大N条记录方法征集,及散分....
from (select * from ware where query_key = 'kakaku' and price>0 order by url,price) t
group by url