以下是我写出的语句,
StrTemp = "select top 1 * from [Repair Record] where [Feeder S/N] ='" & Me.[Feeder SN] & "' and [Repair Record].[Export Time] < (DateAdd(""m"", -4, Now()))"
加红的语句就是我选出的数据,但是我想从选出的数据中只要日期最大的,请问要如何修改,谢谢!
StrTemp = "select top 1 * from [Repair Record] where [Feeder S/N] ='" & Me.[Feeder SN] & "' and [Repair Record].[Export Time] < (DateAdd(""m"", -4, Now()))"
加红的语句就是我选出的数据,但是我想从选出的数据中只要日期最大的,请问要如何修改,谢谢!
解决方案 »
- 分组top查询?
- 急求sql语句
- 同一台相装SQL2000与SQL2005,SQL2005先装,是默认实例名,TCP1433端口,SQL2000后装,localhost\sql2000,假如1533端口,那客户端连接时
- 找得有点累了,也试累了。问一个关于select 和group by 的问题。
- dts包调度失败
- 关于数据库报表统计的问题
- SQL_Latin1_General_CP1_CI_AS 的数据库如何判断全角半角?
- [求助]超时问题
- 这样的查询如何实现
- Format(IIf(Sum([NBR])=0,0,Sum([ANS])/Sum([NBR])),"Percent")在SQLSERVER 中怎样写
- ASP+SQL多条件查询判断是否为空的代码
- 关于SQLSERVER 服务器
2 CM-2X8-1380 715222 2006-9-7 15:18:49 2006-9-9 1:24:35 2006-9-9 2:19:17 2006-9-13 16:17:47 1 0 712738 715206 0 {00A30596-09EB-4239-922D-E51A25FF93EA}
3 CM-2X8-0396 715222 2006-9-7 15:18:52 2006-9-9 1:06:42 2006-9-9 1:23:28 2006-9-13 16:17:38 2 0 712738 715206 1 {9E200BF0-F706-460C-A1A4-D4BCBCB05FC8}
4 CM-2X8-0231 715222 2006-9-7 15:18:58 2006-9-9 0:51:13 2006-9-9 0:55:26 2006-9-13 16:17:39 1 0 712738 715206 1 {AE0FEF2C-1983-418C-AD6F-F67C72850536}
你好!以上就是我的表结构,假如我选择Feeder S/n后,会有一堆数据出来,我只想要export最接近今天的数据就可以了,谢谢!
[ Start time] datetime, [End time] datetime, [Export Time] datetime,
[Re Errors] int, [Parts Sender] int, [Taker s_ColLineage] int, s_Generation int,
s_GUID int, s_Lineage varchar(100))
insert into ta select
2,'CM-2X8-1380',715222,'2006-9-7 15:18:49','2006-9-9 1:24:35','2006-9-9 2:19:17',
'2006-9-13 16:17:47',1 ,0 ,712738 ,715206 ,0 ,'{00A30596-09EB-4239-922D-E51A25FF93EA}'
insert into ta select
3,'CM-2X8-0396', 715222,'2006-9-7 15:18:52','2006-9-9 1:06:42','2006-9-9 1:23:28',
'2006-9-13 16:17:38',2 ,0 ,12738, 715206, 1, '{9E200BF0-F706-460C-A1A4-D4BCBCB05FC8}'
insert into ta select
4,'CM-2X8-0231',715222,'2006-9-7 15:18:58','2006-9-9 0:51:13','2006-9-9 0:55:26',
'2006-9-13 16:17:39',1, 0 ,712738 ,715206, 1, '{AE0FEF2C-1983-418C-AD6F-F67C72850536}'declare @s varchar(1000)
set @S = 'select top 1 * from ta where [Feeder S/N] =''CM-2X8-1380'' and [Export Time] < (DateAdd(mm, -4, getdate())) order by [Export Time] desc '
exec(@s)drop table ta
/*
ID Feeder S/N Employee ID Income time Start time End time Export Time Re Errors Parts Sender Taker s_ColLineage s_Generation s_GUID s_Lineage
----------- ---------------- ----------- ------------------------------------------------------ ------------------------------------------------------ ------------------------------------------------------ ------------------------------------------------------ ------------- ------------ ------------------ ------------ ----------- ----------------------------------------------------------------------------------------------------
2 CM-2X8-1380 715222 2006-09-07 15:18:49.000 2006-09-09 01:24:35.000 2006-09-09 02:19:17.000 2006-09-13 16:17:47.000 1 0 712738 715206 0 {00A30596-09EB-4239-922D-E51A25FF93EA}
*/