22,209
社区成员
发帖
与我相关
我的任务
分享
select
a.id, a.cid, a.pname, a.pic,
row_number() over (partition by b.cid order by a.id)
from
product_cn a inner join corporation_cn b on
a.cid=b.cid
order by
5
--sql 2005
select m.cid,n.id,n.pname,n.pic,
px= row_number() over(partition by n.cid order by n.id)
from Corpoation_cn m , Product_cn n
where m.cid = n.cid
order by px , m.cid
--sql 2000
select m.cid,n.id,n.pname,n.pic,
px=(select count(1) from Product_cn where cid = n.cid and id < n.id) + 1
from Corpoation_cn m , Product_cn n
where m.cid = n.cid
order by px , m.cid