sql语句请大家给我转成ORACLE语句

来源：百度知道编辑：UC知道时间：2024/09/25 01:21:44

declare @sql varchar(500)
select @sql=ISNULL(@sql+'],[','')+aihao from F group by aihao
set @sql='['+@sql+']'
exec('select * from (select country,aihao,c=sum(renshu) from F group by aihao,country) a pivot (max(c) for aihao in('+@sql+'))b')

没有ORACLE10没有PIVOT函数
declare @sql varchar(500)
set @sql = 'select country '
select @sql = @sql + ' , sum(case aihao when ''' + aihao + ''' then renshu else 0 end) [' + aihao + ']'
from (select distinct aihao from F) as a
set @sql = @sql + ' from F group by country'
exec(@sql)
求整体，我才用ORACLE，正在学习中，所以请写出全部的，先谢谢了

declare @sql varchar(500)
set @sql = 'select country '
select @sql = @sql + ' , sum(case aihao when ''' + aihao + ''' then renshu else 0 end) [' + aihao + ']'
from (select distinct aihao from F) as a
set @sql = @sql + ' from F group by country'
exec(@sql)

Oracle--可用 max(case when ...else ..end) as ...静态写法

请指点我SQL语句大家帮我写个SQL语句请帮我写SQL语句一个困惑了我很久的sql查询语句,请大家帮忙,感恩不敬! 请大家帮我看一下这条SQL语句怎么写? 以下几个SQL语句怎样转成HQL语句？请大家给我推荐点经典的语句吧. sql是一个临时表 ,大家给写下语句 sql update 语句的语法错误请大家帮帮忙吧一个SQL语句的问题,请大家指教.谢谢!