Number
1
2
3
4
我怎么得到显示数字(总数10)
select Number as '数字(总和:'"+select sum(Number ) from Test1+"')' from Test1
好象不行啊
1
2
3
4
我怎么得到显示数字(总数10)
select Number as '数字(总和:'"+select sum(Number ) from Test1+"')' from Test1
好象不行啊
select @txt = cast(sum(Number) as varchar(10)) from Test1;
set @txt = 'select sum(Number) as [总和(' + @txt + ')]'+ ' from Test1'
exec sys.sp_sqlexec @txt
select ('数字(总和:'+convert(varchar(50),sum(Number ))+')') as Number from Test1
select @txt = cast(sum(Number) as varchar(10)) from Test1;
set @txt = 'select sum(Number) as [总和(' + @txt + ')]'+ ' from Test1'
exec sys.sp_sqlexec @txt~~~~~~~~~~~~~~~~~
能用一条语句吗?
create table N(id int)insert into N select 1
insert into N select 2
insert into N select 3
insert into N select 4
SELECT DISTINCT '数字总和:'+ (select Cast(sum(id) as varchar(20)) from N) as 查询结果 FROM N
UNION
SELECT CAST(id AS VARCHAR(10)) FROM N
order by 查询结果 desc
结果:
数字总和:10
4
3
2
1
SQL查询出来的数据不都是以表的形式么?