SQL¼ÆËãÄêÁä - MS-SQL Server / »ù´¡Àà

worker(workerno,workername,workersex,workerborndate)

ÏÔʾËùÓÐÖ°¹¤µÄÄêÁ䣬²¢°´Ö°¹¤ºÅµÝÔöÅÅÐò¡£

±íÖÐÖ»ÓÐÔ±¹¤µÄ³öÉúʱ¼ä£¬ÀýÈç1952-01-03


´ËsqlÓïÑÔÈçºÎд£¿ÈçºÎÀûÓÃϵͳʱ¼ä¼ÆËãÄêÁ䣿
Çë¸ßÊÖ°ïæ1

---

SQL code:

select workerno,workername,workersex,datediff(year,workerborndate,getdate())
from worker
order by workerno

---

SQL code:
select workerno,workername,workersex,datediff(year,workerborndate,getdate())+1 as age
from worker
order by workerno

---

SQL code:


if OBJECT_ID('worker') is not null
drop table worker
go
--worker(workerno,workername,workersex,workerborndate)
create table worker(
workerno int,
workername varchar(20),
workersex int,
workerborndate datetime
)
insert into worker
select 3,'pjl',1,'1987-11-02' union all
select 2,'kzd',1,'1988-11-11' union all
select 1,'dyx',1,'1986-01-11'

select * from worker

select workerno,workername,workersex,DATEDIFF(MONTH,workerborndate,GETDATE())/12 as age
from worker
order by workerno
/*

---

¾ÍÕâÑù½áÌùÀ²£¿