SQL问题

[zhanglong19891129]

大侠门这个怎么合并2行啊>???按照 A B 这个的把这个4行合成2行

[SQL77]

SELECT SOKUTENNAME,MAX(A),MAX(B)....
FROM TB
GROUP BY SOKUTENNAME

[骑着蜗牛去爬山]

select max(jojenkaken1),max(jojenkaken1),max(kiteisunpo1),max(kiteisunpo2),sokutenname from tb group by sokutenname

[你的选择B]

--Text
if OBJECT_ID('Text','u') is not null
drop table Text
create table Text
(
JogenKagen1 nvarchar(10),
JogenKagen2 nvarchar(10),
KiteiSunpon1 float,
KiteiSunpon2 float,
SokutenName nvarchar(10)
 )
 go
 insert into Text
 select null,'12~12',null,5.0,'A' union all
 select '10~10',null,4.0,null,'A' union all
 select null,'18~18',null,6.0,'B' union all
 select '15~15',null,8.0,null,'B'
 go
 
 select *From Text
 
 --合并
 select MAX(JogenKagen1) JogenKagen1 ,MAX(JogenKagen2) JogenKagen2,MAX(KiteiSunpon1) KiteiSunpon1,MAX(KiteiSunpon2) KiteiSunpon2,SokutenName
 from Text
 group by SokutenName
 
 --结果
--10~10	12~12	4	5	A
--15~15	18~18	8	6	B

[GiveMePressure]

SELECT MAX(JogenKagen1), MAX(JogenKagen2), MAX(KiteiSunpo1), MAX(KiteiSunpo2), SokutenName FROM TABLE GROUP BY (SokutenName)