update a
set col1=b.col1
from a,(select count( col1) as col1,col2,col3
from c
group by col2,col3) b
where a.col2=b.col2 and a.col3=b.col3
谁能帮我翻译这句话成oracle可以执行的
set col1=b.col1
from a,(select count( col1) as col1,col2,col3
from c
group by col2,col3) b
where a.col2=b.col2 and a.col3=b.col3
谁能帮我翻译这句话成oracle可以执行的
解决方案 »
- 关于ORACLE SPLIT 查询的问题,望大虾解答
- 关于occi在VC6.0工程中编译链接出错的问题,十万火急~~!!!!
- 请教高手帮忙把一条sqlserver的SQL转换成ORACLE的SQL
- 急急急,高分借id
- 函数调用错误:wrong number or types of arguments in call to 'ID_IS_GOOD'
- Oracle 10g 异常
- 大家帮忙看看吧, 这是什么问题
- oracle中select field1 to var1 from table1 where condition出错(马上结帐)
- Oracle805的Utl_raw.bit_or是否存在问题,谁能解释?
- oracle spatial 查询报错 ,急!!!
- ★☆★☆★求实现该操作的一条sql语句★☆★☆★☆
- 求一条sql语句
set
col1=(select count(col1) from c where col2=a.col2 and col3=a.col3)
from
a