这里不便于用Group,试试这个:SELECT BB.*,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO) AS BOOLALL,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 0) AS BOOL0,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 1) AS BOOL1,
FROM (SELECT DISTINCT MYPRO FROM MYTAB) BB
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO) AS BOOLALL,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 0) AS BOOL0,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 1) AS BOOL1,
FROM (SELECT DISTINCT MYPRO FROM MYTAB) BB
解决方案 »
- 這哪錯了?請幫更正,謝謝!
- 如何判断字段含有某个值然后赋一个其它值
- 如何能高效的从多表中查询同一字段?
- Oracle的查询计划在哪里能看到?
- exp导出出错。在线等,急。。。
- 如何用一批量把一个表中的记录导出为“insert into tblName(fieldlist) values(valuelist);”语句
- float字段更新错误????
- oracel的函数问题
- svrmgrl 中的shutdown是卸下数据库实例,但为什么我还是可以进入数据库
- 如何将ORACLE数据库的表记录输出到文本文件(成功后加分100)
- 请问oracle 对表列的个数有要求吗?每个表最多有多少个列?
- 过年不能留遗憾呀,高手请进!!!!!!!!!!!!!!!!!!救命呀!!!!!!!!!!!
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO) AS BOOLALL,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 0) AS BOOL0,
(SELECT COUNT(*) FROM MYTAB WHERE MYPRO = BB.MYPRO AND MYBOOL = 1) AS BOOL1
FROM (SELECT DISTINCT MYPRO FROM MYTAB) BB