--> 数据库版本: --> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 --> 测试数据:[TB] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]') AND type in (N'U')) DROP TABLE [TB] GO---->建表 create table [TB]([ime] datetime) insert [TB] select '2009-08-03 16:00:00' union all select '2009-09-01 17:00:00' union all select '2009-09-30 18:00:00' GO--> 查询结果 SELECT * FROM [TB] where datepart(mm,ime)= (select max(MONTH(ime)) from TB) --> 删除表格 --DROP TABLE [TB]
如果有多表,表之间如何关联?
发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
2009-08-03 16:00:002009-09-01 17:00:002009-09-30 18:00:00-----------------------------------
就这三条数据,我想得到离现在日期最近的那一个月所有的内容,也就是我想得到
2009-09-01 17:00:002009-09-30 18:00:00
这两个日期该怎么写
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO---->建表
create table [TB]([ime] datetime)
insert [TB]
select '2009-08-03 16:00:00' union all
select '2009-09-01 17:00:00' union all
select '2009-09-30 18:00:00'
GO--> 查询结果
SELECT *
FROM [TB] where datepart(mm,ime)= (select max(MONTH(ime)) from TB)
--> 删除表格
--DROP TABLE [TB]