在sql plus里面怎样用SELECT怎样取几千条记录的前十条?

光这个还没完,
取完后还要显示sum(top 10) / sum(all)的百分比.
谢谢!
我想了一下午都没想出来.
top n 的语法好象用不起来嘛!

[112 byte] By [galiton-galiton] at [2008-6-10]

«« 近来问题太多啊?
»» weblogic7中如何建立SQL SERVER2000的连接池呀?

# 1

select top 10 sum(字段名) from 表名

billyliu-小流 at 2007-10-28 >

# 2

rownum < 11

jlandzpa-jlandzpa at 2007-10-28 >

# 3

select sum(age)/sum(age2) from (select age from tbname where rownum<11),(select age age2 from tbname);

bzszp-SongZip at 2007-10-28 >

# 4

SELECT * FROM TNAME WHERE ROWNUM<11;

blue__star-蓝色沸点 at 2007-10-28 >

# 5

agree above

bjwan-bjwan at 2007-10-28 >

# 6

select a.top_nalues/b.all_values from
(select sum(values) top_values from tname where rownum<11 order by desc ) a,
(select sum(values) all_values from tname) b

zhoubf725-zhoubf725 at 2007-10-28 >

# 7

SELECT
(SELECT SUM(A.COL1) FROM A WHERE ROWNUM<5)/(SELECT SUM(A.COL1) FROM A)
FROM DUAL

CHENGXB-阿困 at 2007-10-28 >

# 8

SORRY,上面的ROWNUM<11

CHENGXB-阿困 at 2007-10-28 >

# 9

Thanks everyone

galiton-galiton at 2007-10-28 >

Oracle

开发

程序员与开发者之家是一个面向广大程序员与开发者的信息资讯网站,主要介绍和发布各类程序示例和所遇到的问题,是IT技术社区,为IT专业技术人员提供最全面的信息传播和服务

在sql plus里面怎样用SELECT怎样取几千条记录的前十条?

Oracle Hot Topic

Oracle New Topic

Oracle

Site Classified