insert into tb1(url, count_url)
select distinct url, count_url
from (select url, count_url, rank() over(group by url order by count_url desc ) rk
from tb2 where year='2004' and month='11') t
where t.rk <= 9;这么写试试
select distinct url, count_url
from (select url, count_url, rank() over(group by url order by count_url desc ) rk
from tb2 where year='2004' and month='11') t
where t.rk <= 9;这么写试试
解决方案 »
- 求一sql语句,在线等!!
- 郁闷
- 如何在出发其中获得新增行的各个字段的值,并将其插入另一个表中?
- 在线送分,怎样给一个数据库配置多个服务名(Service_name),解决了马上给分
- 分組查詢后排名次
- Oracle中数据类型转化的问题。
- 对于几十万条记录的表,如何解决效率问题
- 我想请问有哪几个比较好的oracle的学习网站,最好是BBS的!还有求一个ftp下载oracle!
- 那里有developer2000的下载????
- Oracle 8i R2 (8.1.6) for NT 企业版在windows 2000 advanced server下的安装?
- 表的一个字段由varchar2(50)改为varchar2(200)后,只要输入的字符超过50就会让这个表所有字段不能update,delete
- 请教:关于利用一个表更新第二个表格的方法问题
(URL, COUNT_URL)
SELECT DISTINCT URL, COUNT_URL
FROM (SELECT URL, COUNT_URL, RANK() OVER(ORDER BY COUNT_URL DESC) RK
FROM TB2
WHERE YEAR = '2004'
AND MONTH = '11') T
WHERE T.RK <= 9;