insert into card_reward(id,积分,......,时间) select id,积分,......,sysdate from (select id,积分,......,row_number() over (order by 积分) as rn from card_card) where rn<=100
上面的回答了 如果需要有并列前100名 就把row_number换成dense_rank
我是初学者,还是不太明白(select id,积分,......,row_number() over (order by 积分) as rn from card_card) 是什么意思,row_number我并没有定义啊,还有row_number() over (order by 积分) as rn不太明白,在帮帮我,告诉我一下
row_number()是个自动产生行号函数,随机产生,在select 语句里有多少行,就自动产生多少行 row_number() over (order by 积分) 按"积分"排序产生行号
select id,积分,......,sysdate from
(select id,积分,......,row_number() over (order by 积分) as rn from card_card)
where rn<=100
如果需要有并列前100名
就把row_number换成dense_rank
是什么意思,row_number我并没有定义啊,还有row_number() over (order by 积分) as rn不太明白,在帮帮我,告诉我一下
row_number() over (order by 积分) 按"积分"排序产生行号
http://www.cnblogs.com/liguiqing/archive/2007/11/20/966003.html