select top 1 InsertTime,StockID,StockValue,Creator from PDS_SpeedStock where InsertTime=(select max(InsertTime) from PDS_SpeedStock)
这样?
追问根据我当前传的时间来获取他前一条数据
追答什么意思?能用数据简单说明一下吗?
追问比如 数据库里有几条数据时间分别是
2013-12-16,
2013-12-17,
2013-12-18,
2013-12-19,
写一条sql根据我传入的时间来获取他前一条数据
如我输入2012-12-20获取到2013-12-19
输入2013-12-17 获取到2013-12-16
追答select InsertTime,StockID,StockValue,Creator from PDS_SpeedStock
where
datediff(day,InsertTime,cast('2013-12-20' as datetime))=
(select min(datediff(day,InsertTime,cast('2013-12-20' as datetime))) from
PDS_SpeedStock where datediff(day,InsertTime,cast('2013-12-20' as datetime))>0)本回答被提问者采纳