如何实现前N行数据的查询？？？急急？在线等！！！！！

[hesandy]

查询语句
SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0

CDR表

ID NUMBER(38) not null,
GLOBALCALLID_CALLMANAGERID NUMBER(38) not null,
GLOBALCALLID_CALLID NUMBER(38) not null,
COMMENTS VARCHAR2(256)

CMR表
GLOBALCALLID_CALLMANAGERID NUMBER(38) not null,
GLOBALCALLID_CALLID NUMBER(38) not null,
RECORDTIME TIMESTAMP(6)

[hesandy]

CDR表为
ID NUMBER(38) not null,
GLOBALCALLID_CALLMANAGERID NUMBER(38) not null,
GLOBALCALLID_CALLID NUMBER(38) not null,

QOSLEVELFLAG NUMBER(1) default 0,

COMMENTS VARCHAR2(256)

[tcmis]

SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0 and rownum < 100;
是不是这个意思。。rownum < 100就是前99条记录

[guanshiyu123]

SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0

加一个条件
rownum <= n.... n你自己定

变为:SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0 and rownum <= n

[hesandy]

就是符合条件的钱N行纪录，要不要用order by ID呀

[guanshiyu123]

这个rownum 系统自动读出的前n个
不要进行排序

[guanshiyu123]

如果你的条件要求先排序再取前n....这就比较麻烦...

[waterfirer]

取前n-1条记录
select * from (SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0
) where rownum<n
如果需要排序，在里面写
select * from (SELECT a.* FROM CDR a,CMR b WHERE a.GLOBALCALLID_CALLMANAGERID = b.GLOBALCALLID_CALLMANAGERID and a.GLOBALCALLID_CALLID = b.GLOBALCALLID_CALLID and a.QOSLEVELFLAG=0 order by ......
) where rownum<n