select *
from(
select b.*,p.*,row_number()over(order by b.datetime desc) rn from t_bss_product_key_info p,t_bss_bill_key b where p.Product=b.Product(+)
and p.id=b.keyNo(+) and p.id in(7,24,35)
order by b.datetime desc)
where rn between 20 and 30;
from(
select b.*,p.*,row_number()over(order by b.datetime desc) rn from t_bss_product_key_info p,t_bss_bill_key b where p.Product=b.Product(+)
and p.id=b.keyNo(+) and p.id in(7,24,35)
order by b.datetime desc)
where rn between 20 and 30;
解决方案 »
- oracle客户端与服务器端字符集不一样怎么办?
- 菜鸟求助,简单的插入语句……感激!!!
- 如何调用另一个ORACLE实例的存储过程??求救
- 问一个问题
- 请问:Oracle中,如何得到某个日期的年份?
- 在线等 oracle 导出全部表!!!!!!!!!
- 关于一个不好处理的order by 有难度 请帮忙
- 哪里有学习pl/sql的好教程,高分相赠
- DataFactory连接oracle报错 NO access library for'or84d.dll'
- 如何将Excel表结构导入到Powerdesigner中
- 【alter database backup controlfile to trace 后需要怎样的命令才能恢复controlfile?】
- 请问为什么我在 SQL*PLUS 中用insert添加记录后看不到?
SELECT B.*,P.*,ROW_NUMBER()OVER(ORDER BY B.DATETIME DESC) RN
FROM T_BSS_PRODUCT_KEY_INFO P,T_BSS_BILL_KEY B
WHERE P.PRODUCT=B.PRODUCT(+)
AND P.ID=B.KEYNO(+)
AND P.ID IN(7,24,35)
)
SELECT Y.*
FROM Y
WHERE Y.RN BETWEEN 20 AND 30楼上的回复也应该是正解
我用你的显示 column ambiguously defined 字段定义模糊
我也不知道怎么弄 我把表结构给你:
-----------t_bss_bill_key-------------
wirecorp product channle datetime timesum usersum avgtime keyno-----------t_bss_product_key_info-------------
wirecorp product key introduce id channle
↓
select *
from(
select b.*,p.*,row_number()over(order by b.datetime desc) rn from t_bss_product_key_info p,t_bss_bill_key b where p.Product=b.Product(+)
and p.id=b.keyNo(+) and p.id in(7,24,35)
order by b.datetime desc)
where rn between 20 and 30;
select *
from(
select b.wirecorp b_wriecorp,b.datetime,p.wirecorp p_wirecorp,p.channle,row_number()over(order by b.datetime desc) rn from t_bss_product_key_info p,t_bss_bill_key b where p.Product=b.Product(+)
and p.id=b.keyNo(+) and p.id in(7,24,35)
order by b.datetime desc)
where rn between 20 and 30;