(select count(*) from t_familymember tf where tf.familyid in (select familyid from t_publicrentcontract
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))*
((select count(*)from t_publicrentcontract
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))这样写哪里错了呢?报SQL命令未正确结束
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))*
((select count(*)from t_publicrentcontract
where operationtype=3 and familyid in
(select id from t_familybasicinfo where county=305 and id=808)))这样写哪里错了呢?报SQL命令未正确结束
解决方案 »
- 求CXF与spring结合并且加入头信息验证的方法或者例子?
- jdk6已经将Derby数据库做为一部分了,csdn上也要开一个Derby版,支持的顶一个!!!
- xmlHttp.responseXMl 获取不到值,- ajax !!!
- 在线等答案 请达人指导
- 菜鸟问:JavaBean是不是就相当于组件啊?
- 请写过单体测试用例的人指教该如何写?
- 急!!!!
- 我已经下载了JDBC驱动,可是不知道该怎么安装,高手说一下具体的过程好吗?
- 有关CMP 中处理 Blob Clob 字段的 问题 讨论
- java接口泛型.class获取
- 谁能给个SSH2 列表分页的简单例子
- 奋战2周struts2+Hibernate+spring+extjs的图书管理系统终于完成了!发帖纪念一下
FROM t_familymember tf
WHERE tf.familyid IN
(SELECT familyid
FROM t_publicrentcontract
WHERE operationtype = 3
AND familyid IN
(SELECT id
FROM t_familybasicinfo
WHERE county = 305 AND id = 808)))
*( (SELECT COUNT ( * )
FROM t_publicrentcontract
WHERE operationtype = 3
AND familyid IN (SELECT id
FROM t_familybasicinfo
WHERE county = 305 AND id = 808)))
from dual
FROM t_familymember tf
WHERE tf.familyid IN
(SELECT familyid
FROM t_publicrentcontract
WHERE operationtype = 3
AND familyid IN
(SELECT id
FROM t_familybasicinfo
WHERE county = 305 AND id = 808)))
*( (SELECT COUNT ( * )
FROM t_publicrentcontract
WHERE operationtype = 3
AND familyid IN (SELECT id
FROM t_familybasicinfo
WHERE county = 305 AND id = 808)))