求SQL:怎样求两列的平均数,然后把值作为第三列 sql求平均生成新列 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select S_Name , S_YuWen, S_ShuXue,(S_YuWen+S_ShuXue)/2.0 as S_AVGfrom T ------------------------------------------------------------------ Author :DBA_Huangzj(發糞塗牆)-- Date :2014-02-13 11:38:06-- Version:-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )--------------------------------------------------------------------> 测试数据:[T]if object_id('[T]') is not null drop table [T]go create table [T]([S_Name] varchar(4),[S_YuWen] int,[S_ShuXue] int)insert [T]select '张三',80,80 union ALLselect '李五',0,100--------------开始查询--------------------------select *,([S_YuWen]+[S_ShuXue])/2 from [T] GROUP BY [S_Name],[S_YuWen],[S_ShuXue]----------------结果----------------------------/* S_Name S_YuWen S_ShuXue ------ ----------- ----------- -----------李五 0 100 50张三 80 80 80*/ ------------------------------------------------------------------ Author :DBA_Huangzj(發糞塗牆)-- Date :2014-02-13 11:38:06-- Version:-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )------------------------------------------------------------------这个是模板吗?咋弄出来的? ------------------------------------------------------------------ Author :DBA_Huangzj(發糞塗牆)-- Date :2014-02-13 11:38:06-- Version:-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )------------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密... select *, (S_YuWen+S_ShuXue)/2 as S_AVG from T 好奇怪,我自己的环境,不用GROUP BY 额...写错了,上面的代码不需要group by,一开始我用了avg,忘了去除而已 ------------------------------------------------------------------ Author :DBA_Huangzj(發糞塗牆)-- Date :2014-02-13 11:38:06-- Version:-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )------------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密...我也很好奇这一段作者信息是怎么弄上去的,之前Eclipse可以有快捷键... sql就不知道怎么弄了 好奇害死猫,还是不要知道为好------------------------------------------------------------------ Author :DBA_Huangzj(發糞塗牆)-- Date :2014-02-13 11:38:06-- Version:-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) -- Dec 28 2012 20:23:12 -- Copyright (c) Microsoft Corporation-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )------------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密...我也很好奇这一段作者信息是怎么弄上去的,之前Eclipse可以有快捷键... sql就不知道怎么弄了 这个应该是预先放到一个sql文件中,然后版主手动输入的把。 还是用除的方便~select S_Name,S_ShuXue,S_YuWen, (S_ShuXue+S_YuWen)/2 as S_Avg from aa Microsoft SQL Server 2012我看到了版本号,也许是版主用了直接生成SQL语句,然后改成自己的名字 求一个SQL 如何将SQL表中数据导出到access中 一个有关SQL的执行效率的问题 一个算法问题,各位大哥请进,很急~ sql 触发器触发外部程序 如何求是否末级科目? 数据修改问题 大侠们,问个查询语句! 誰能用SQL SERVER 2000幫忙給一個16進制轉成10進制的函數 简单问题,同样给高分! 关于sql查询语句的一个问题 写在创建数据库之前的几行代码,求解释。。。。。。。。。。。。。。。。。。
from T
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-13 11:38:06
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------
--> 测试数据:[T]
if object_id('[T]') is not null drop table [T]
go
create table [T]([S_Name] varchar(4),[S_YuWen] int,[S_ShuXue] int)
insert [T]
select '张三',80,80 union ALL
select '李五',0,100
--------------开始查询--------------------------select *,([S_YuWen]+[S_ShuXue])/2
from [T]
GROUP BY [S_Name],[S_YuWen],[S_ShuXue]
----------------结果----------------------------
/*
S_Name S_YuWen S_ShuXue
------ ----------- ----------- -----------
李五 0 100 50
张三 80 80 80
*/
----------------------------------------------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-13 11:38:06
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------这个是模板吗?咋弄出来的?
----------------------------------------------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-13 11:38:06
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密...
select *, (S_YuWen+S_ShuXue)/2 as S_AVG from T
好奇怪,我自己的环境,不用GROUP BY
----------------------------------------------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-13 11:38:06
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密...我也很好奇这一段作者信息是怎么弄上去的,之前Eclipse可以有快捷键... sql就不知道怎么弄了
----------------------------------------------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2014-02-13 11:38:06
-- Version:
-- Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
-- Dec 28 2012 20:23:12
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
--
----------------------------------------------------------------这个是模板吗?咋弄出来的?商业机密...我也很好奇这一段作者信息是怎么弄上去的,之前Eclipse可以有快捷键... sql就不知道怎么弄了
select S_Name,S_ShuXue,S_YuWen, (S_ShuXue+S_YuWen)/2 as S_Avg from aa