阅读背景:

如何选择Min和Next Min并在与相关查询相同的行上显示

来源:互联网 

I used this SQL:

我用过这个SQL:

/****** Select Min and Next Min with Bike ID  ******/
SELECT
t.[bike_id] 
,min(t.[start_date]) as Min_Date
,(SELECT min([start_date]) From trip Where [start_date] > (SELECT min([start_date]) From trip)) as Next_Min_Date
FROM [dbo].[trip] t
Group By t.[bike_id] 
Having t.[bike_id] < '15'
/****** Select M



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: