求一个sql谢谢

[Persistence_x]

谢谢

[Persistence_x]

引用 1 楼 fredrickhu 的回复:

你这个应该可以用SUM(CASE WHEN ...)来解决。

还是不太明白，嘀咕不出来了

[Persistence_x]

引用 3 楼 DBA_Huangzj 的回复:

前三个查询要带出一个标识列，然后和第四个查询join起来

还是不太明白，

[Persistence_x]

引用 2 楼 chz415767975 的回复:

举个例子给你

select (select count(*) from tb) as [sum1],(select count(*) from tb2) as [sum2],(select count(*) from tb3) as [sum3]

这样不可以吧

[--小F--]

你这个应该可以用SUM(CASE WHEN ...)来解决。

[霜寒月冷]

举个例子给你

select (select count(*) from tb) as [sum1],(select count(*) from tb2) as [sum2],(select count(*) from tb3) as [sum3]

[發糞塗牆]

前三个查询要带出一个标识列，然后和第四个查询join起来

[xxfvba]

cross apply 可以吗 select id,des,qty,amt from (select '1' as id,2 as Qty) a cross apply (select 3 as amt) b cross apply (select 4 as des)c

[白开水太浓]

引用 6 楼 xiaohuaidan1988 的回复:

[quote=引用 2 楼 chz415767975 的回复:] 举个例子给你

select (select count(*) from tb) as [sum1],(select count(*) from tb2) as [sum2],(select count(*) from tb3) as [sum3]

这样不可以吧[/quote] 这样是可以的，你试试，把你前面三条语句根据这方法放进去