你的SQL少了个FROM 吧
应该为这样吧:
SELECT B.ID, B.KID
from (SELECT A.ID,
A.KID,
ROW_NUMBER() OVER(PARTITION BY A.ID ORDER BY A.BEGINDATE DESC) AS XH
FROM T_BANK_DKDATA A) B
WHERE B.XH = 1;
另外帮你写了个SQL:select b.id, a.kid
from t_bank_dkdata a,
(select a.id, max(a.begindate) xh from t_bank_dkdata a group by a.id) b
where b.id = a.id
and b.xh = a.begindate
应该为这样吧:
SELECT B.ID, B.KID
from (SELECT A.ID,
A.KID,
ROW_NUMBER() OVER(PARTITION BY A.ID ORDER BY A.BEGINDATE DESC) AS XH
FROM T_BANK_DKDATA A) B
WHERE B.XH = 1;
另外帮你写了个SQL:select b.id, a.kid
from t_bank_dkdata a,
(select a.id, max(a.begindate) xh from t_bank_dkdata a group by a.id) b
where b.id = a.id
and b.xh = a.begindate
解决方案 »
- 在本地导出远程数据库到本地:是先建立database link, 还是在本地先建立远程服务器的服务命名并加入监听,然后用exp导出???
- oracle 中怎样执行自定义函数(函数中有修改数据库的操作)
- java 调用oracle存储过程建表出错,求解
- 破坏control file
- 用jdbc连不上Oracle,怎么解决?
- 求教大家,这种展现效果,数据库该如何设计好呢?
- oracle下dmp文件如何在windows下文本或excel打开,急呀!!
- 请教oracle冷备份
- 请教所有纪录追加到另一个数据库中的方法
- 关于ORACLE数据库的迁移.
- 主表一个字段存储字典表的多个ID值时,大牛求解决方案???
- 数据库中三表关联,查询的小问题,在线等
select a.id,a.kid,min(a.begindate) from T_bank_DKDATA a
WHERE A.BEGINDATE <=
TO_DATE('2013-12-02', 'YYYY-MM-DD') group by a.id,a.kid