iddatetime idname
2006-4-27 15:00:00 Miller
2006-4-27 16:00:00 Miller
2006-4-27 15:00:00 Jerry
2006-4-27 16:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerry现在需要列出每天最大记录和最小记录存成两张表table A(最小记录)
iddatetime idname
2006-4-27 15:00:00 Miller
2006-4-27 15:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerrytable B(最大记录)
iddatetime idname
2006-4-27 16:00:00 Miller
2006-4-27 16:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerry谢谢
2006-4-27 15:00:00 Miller
2006-4-27 16:00:00 Miller
2006-4-27 15:00:00 Jerry
2006-4-27 16:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerry现在需要列出每天最大记录和最小记录存成两张表table A(最小记录)
iddatetime idname
2006-4-27 15:00:00 Miller
2006-4-27 15:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerrytable B(最大记录)
iddatetime idname
2006-4-27 16:00:00 Miller
2006-4-27 16:00:00 Jerry
2006-4-28 16:00:00 Miller
2006-4-28 16:00:00 Jerry谢谢
解决方案 »
- 求教一下高手,看一下我这语句哪错了?
- telnet localhost 1433
- SQL Server中如何枚举两个日期之间的所有日期值?
- 无语求教
- 关于数据分页问题。
- 一个关于触发器的问题
- sqlserver2008 inset出错:无法打开与 SQL Server 的连接 [53]. 求高手解答
- 数据库视图(View)和基表(Table)数据同步的问题???
- 由于数据库日志文件太大,数据库还原时提示“磁盘空间不足”,可否在还原时将日志文件清空
- 如何获知SQL SERVER 2000下某一个连接已经断开
- Group By 和LEFT JOIN的问题
- insert into table select 的问题
group by iddatetime,idname
order by idnameselect top 1 iddatetime,idname into #tableB from 表1
group by iddatetime,idname
order by idname dese
Insert into A(iddatetime,idname)
select iddatetime,idname
from tbl as a
where iddatetime=(select top 1 iddatetime from tbl where idname=a.idname
and datediff(day,a.iddatetime,iddatetime)=0 order by iddatetime)--取大
Insert into B(iddatetime,idname)
select iddatetime,idname
from tbl as a
where iddatetime=(select top 1 iddatetime from tbl where idname=a.idname
and datediff(day,a.iddatetime,iddatetime)=0 order by iddatetime desc)
insert into @t select '2006-4-27 15:00:00' , 'Miller'
union all select '2006-4-27 16:00:00' , 'Miller'
union all select '2006-4-27 15:00:00' , 'Jerry'
union all select '2006-4-27 16:00:00' , 'Jerry'
union all select '2006-4-28 16:00:00' , 'Miller'
union all select '2006-4-28 16:00:00' , 'Jerry'select * from @t a where not exists(select 1 from @t where convert(varchar(10),iddatetime,120)=convert(varchar(10),a.iddatetime,120) and convert(varchar,iddatetime,108)>convert(varchar,a.iddatetime,108))
select * from @t a where not exists(select 1 from @t where convert(varchar(10),iddatetime,120)=convert(varchar(10),a.iddatetime,120) and convert(varchar,iddatetime,108)<convert(varchar,a.iddatetime,108))