select nvl(name,name1) as name,sum(num1) as num1,sum(num2) as num2 from

(

select NULL as name,'李四' as name1,null as num1,20 as num2 from dual

union all

select NULL,'李五',null as num1,30 as num2 from dual

union all

select '李四',null,60 as num1,null as num2 from dual

union all

select '李五',null,30 as num1,null as num2 from dual

union all

select '张三','张三',10 as num1,10 as num2 from dual

)

GROUP BY nvl(name,name1)

数据库拼接语句

下面列举三大主流数据库的处理方式

1）Oracle 的拼接与 SQLite 的一致

SELECT user||'-'||name as username,password,position,area FROM user

2）SQL Server 使用+号进行拼接

SELECT user+'-'+name as username,password,position,area FROM user

3）MySQL 使用 concat 函数进行拼接

SELECT concat(user,'-',name) as username,password,position,area FROM user

select if(name is null ,name(1),name) name

    ,english

    ,french

from  table 

这样的吗？