这个咋整?解决思路
这个咋整?
time name0 name1 name2
time1 a1 null null
time1 null b1 null
time1 null null c1
to
time name0 name1 name 2
time1 a1 b1 c1
------解决方案--------------------
select time,max(name0),max(name2),max(name2)
from 表
group by time
time name0 name1 name2
time1 a1 null null
time1 null b1 null
time1 null null c1
to
time name0 name1 name 2
time1 a1 b1 c1
sql
------解决方案--------------------
select time,max(name0),max(name2),max(name2)
from 表
group by time