sqlite 貌似没有row_number ;
从你的sql来看,是不是需要一个“排名”字段来存储order by cost后的序号?
select
(select count(*) from (select *
,b.COUNTRY||'-'||b.CITY as '地区'
from PRODUCT a
left join PRODUCER b
on a.producerid=b.producerid order by a.cost) b where a.cost >= b.cost) as "排名"
,*
from (select *,b.COUNTRY||'-'||b.CITY as '地区'
from PRODUCT a left join PRODUCER b
on a.producerid=b.producerid order by a.cost) as a
order by cost;
不知道能不能满足?