HAVING F_RQ=MAX(F_RQ) --这一句出问题,having关键字不可能认识F_RQ,它不属于分组功能.SELECT F_SPNM, F_BMNM, F_JYFS,max(f_rq) f_rq
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS
解决方案 »
- 急:在RHEL 4下面安装Oracle 10g,报OUI-10118错误:加载安装组件时products.xml文件不存在或者读取失败
- 大家好,问个简单的问题(power designer)
- XML专家请进,小二有钱伺候~~~
- Oracle-01552 Oracle-00600
- 菜鸟提问:这个函数哪儿错了?提示“fdff无效”
- oracle 中 SQL PLUS环境中使用某个数据库用什么命令啊
- 新手提问题 imp 和 exp
- tnsname.ora文件中servers_name与sid有何区别?
- 客户端连接时出现 ora-12545 tns:name lookup failure 是怎么回事?服务器能连上!!!急!急!急!
- 求存储过程,刚学,不懂得写
- 关于dbms_sql包的问题。
- 时间差
如果要插入
INSERT INTO TABLE1(F_SPNM, F_BMNM, F_JYFS, F_XM1, F_XM2, F_XM3)
SELECT F_SPNM, F_BMNM, F_JYFS,
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS
HAVING F_RQ=MAX(F_RQ)
该怎么办?这时不能 max(f_rq) f_rq 在SELECT 语句中了,盼赐教
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS, F_RQ
HAVING F_RQ=MAX(F_RQ)
SELECT F_SPNM, F_BMNM, F_JYFS,
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS 这样就是了
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS, F_JCSL,F_LSDJ,F_JCSL,F_PJJJ,F_JCYS
HAVING F_RQ=MAX(F_RQ) 以下面的方式也不行:
INSERT INTO TABLE1(F_SPNM, F_BMNM, F_JYFS, F_XM1, F_XM2, F_XM3) SELECT F_SPNM, F_BMNM, F_JYFS,
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS, F_JCSL,F_LSDJ,F_JCSL,F_PJJJ,F_JCYS
HAVING F_RQ=(SELECT MAX(F_RQ) FROM HSSPRJZ)
INSERT INTO TABLE1(F_SPNM, F_BMNM, F_JYFS, F_XM1, F_XM2, F_XM3)
SELECT F_SPNM, F_BMNM, F_JYFS,
max(round(F_JCSL * F_LSDJ,2)),
max(round(F_JCSL * F_PJJJ,2)),
max(round(F_JCYS, 2))
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS