select item_id,min(unit_price) as unit_price_min
from secom_sbc_lists
where ssl.internal_status='VALID'
group by item_id
select *
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 ) rn
from secom_sbc_lists ssl
where ssl.internal_status='VALID'
) sslv where sslv.rn=1
