sql语句.txt

来自「将使用数据库和Java技术」· 文本 代码 · 共 30 行

--本系统使用的是SQL数据库
--ODBC数据源名称为：JAVADB

create database JAVADB
go
use JAVADB
create table Gantt(TaskID int not null,Task varchar(50) ,StartTime datetime,EndTime datetime)
go

--数据测试
insert into gantt values(1,'需求分析','2003-10-1','2003-10-9')
insert into gantt values(2,'概要设计','2003-10-10','2003-10-20')
insert into gantt values(3,'详细设计','2003-10-21','2003-10-31')
insert into gantt values(4,'编程','2003-11-1','2003-11-10')
insert into gantt values(5,'测试','2003-11-11','2003-11-30')

select datediff(dd,starttime,endtime) as days,task from gantt
select datediff(dd,min(starttime),max(endtime)) as days from gantt





select datediff(dd,min(starttime),max(endtime)) as distances from gantt
select datediff(wk,min(starttime),max(endtime)) as distances from gantt
select datediff(mm,min(starttime),max(endtime)) as distances from gantt
select datediff(qq,min(starttime),max(endtime)) as distances from gantt
select datediff(yy,min(starttime),max(endtime)) as distances from gantt