摘要：
select item_id,min(unit_price) as unit_price_minfrom secom_sbc_listswhere ssl.internal_status='VALID'group by item_idselect * from(select ssl.sbc_list_id,ssl.item_id,ssl.unit_price,ssl.sbc , row_number() over(PARTITION BY ssl.item_id ORDER BY ssl.unit_price asc ) rnfrom secom_sbc_lists sslwh 阅读全文
posted @ 2012-03-09 17:11 奥客 阅读(158) 评论(0) 推荐(0) 编辑