X
xiangyehpu
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE TABLE [dbo].[GFM_VehicleStatusPosition] (
[ID] [BigInt] IDENTITY (1, 1) NOT NULL ,
[VehicleID] [Int] NULL,
[GPSDateTime] [datetime] NULL,
[Speed] [Decimal] (8,5) NULL,
) ON [PRIMARY]
GO
车辆上发消息时间间隔(即GPSDateTime间隔)为1分钟,假设同一车辆(同VehicleID)在5分钟内速度(Speed)低于5即认为该车处于静止状态
要得到一天以内一车辆处于静止的记录,求查询语句
[ID] [BigInt] IDENTITY (1, 1) NOT NULL ,
[VehicleID] [Int] NULL,
[GPSDateTime] [datetime] NULL,
[Speed] [Decimal] (8,5) NULL,
) ON [PRIMARY]
GO
车辆上发消息时间间隔(即GPSDateTime间隔)为1分钟,假设同一车辆(同VehicleID)在5分钟内速度(Speed)低于5即认为该车处于静止状态
要得到一天以内一车辆处于静止的记录,求查询语句