求80年代出生員工平均年齡 现有员工资料表,只有出生年月,要求80年代员工的平均年龄应该怎样写SQL语句初学者,麻烦知道的写详细些 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select avg(sum(year([date]))) from tablename where year([date])>=80 select cast(avg(datediff(yy,dt , getdate())*1.0) as decimal(18,2)) from tb where substring(convert(varchar(10),dt,120) ,3,2) between '80' and '89' select avg(age) from tb where datepart(yy,时间字段) between 1980 and 1989 select avg(sum(year([date]))) from tablename where year([date])>=1980 select avg(year(getdate())-(year([date]))) from tablename where year([date])>1980 and year([date])<1990 select cast(avg(datediff(yy,dt , getdate())*1.0) as decimal(18,2)) from tb where datepart(yy,dt) between 1980 and 1989 select avg(2009-year(出生年月))from tablewhere year(出生年月) between 1980 and 1989 --?select avg(datediff(year,日期字段,getdate()))from tb where 日期字段 between '1980-01-01' and '1980-12-31' select avg(sum(year([date]))) from tablename where year([date]) between 1980 and 1989 select avg(sum([date]))) from tablename where year([date])>=1980 and year([date])<1990 #9楼 得分:0回复于:2009-12-25 15:59:43SQL codeselect avg(sum(year([date]))) from tablename 请问大家帮我看一下,我的问题需不需要使用数据库啊?? 50分求ADOConnection连接到MSDE的字符串代码[局域网中] 查找日期最早資料 能否对一个字段里的两个值分别计算 SQL 问题 mysql安装一个很奇怪的问题 大家进来看看,帮忙解决哈 论坛的数据库问题 如何记录一切——求高手指点 有个问题高分请大家帮忙 为何在其它服务器使用link server 执行sql时间比原服务器更快? SQL 语句问题 如何去除null,得到一下结果
select cast(avg(datediff(yy,dt , getdate())*1.0) as decimal(18,2)) from tb where substring(convert(varchar(10),dt,120) ,3,2) between '80' and '89'
where datepart(yy,dt) between 1980 and 1989
from table
where year(出生年月) between 1980 and 1989
select avg(datediff(year,日期字段,getdate()))
from tb
where 日期字段 between '1980-01-01' and '1980-12-31'