CREATE TABLE [dbo].[aaa](
[id] [int] IDENTITY(1,1) NOT NULL,
[haha] [int] NULL,
[heihei] [int] NULL
)
然后这个表里面有如下数据:
1 2
2 3
3 4然后我想得到如下结果,就是把这两个和并列在一行中展示,即
6 9我现在的想法是写成下面的形式,不过报错,希望大家给于正确的方法
( select sum(haha) from aaa
left join
(select sum(heihei) from aaa )
[id] [int] IDENTITY(1,1) NOT NULL,
[haha] [int] NULL,
[heihei] [int] NULL
)
然后这个表里面有如下数据:
1 2
2 3
3 4然后我想得到如下结果,就是把这两个和并列在一行中展示,即
6 9我现在的想法是写成下面的形式,不过报错,希望大家给于正确的方法
( select sum(haha) from aaa
left join
(select sum(heihei) from aaa )
select sum(haha),sum(heihei) from aaa
[id] [int] IDENTITY(1,1) NOT NULL,
[haha] [int] NULL,
[heihei] [int] NULL
) insert into aaa(haha,heihei) values(1 ,2)
insert into aaa(haha,heihei) values(2 ,3)
insert into aaa(haha,heihei) values(3 ,4)
goselect sum(haha) , sum(heihei) from aaadrop table aaa/*
----------- -----------
6 9(所影响的行数为 1 行)
*/
不是一个表的情况,比如第二列在另外一个表bbb中
要想得到如下结果应该怎么办呢
create table bbb
(
id int identity(1,1) primary key,
heihei int
)insert into bbb values (2)
insert into bbb values (2)
insert into bbb values (2)CREATE TABLE [dbo].[aaa](
[id] [int] IDENTITY(1,1) NOT NULL,
[haha] [int] NULL
)
然后这个表里面有如下数据:
insert into bbb values (1)
insert into bbb values (1)
insert into bbb values (1)
我想得到类似
select sum(haha) from aaa, select sum(heihei) from bbb
也就是联合展现出来的结果,在一行中并列展示,应该如何办呢?
from aaa
left join bbb on aaa.id = bbb.id
(select sum(haha) from aaa) as a,
(select sum(heihei) from bbb) as b
union select 0 c,sum(bbb.id) d from bbb)