sql - 如何找到两个最近时间sql的时间差

Question

我有一个包含这些列的表：customer_id、time、tickets。如何查询每个 customer_id 的最近两次时间之间的时间差？

我正在尝试使用 row_number() 和自加入。想知道以下是否可行：

Select  customer_id, table.time - tb2.time as time_difference,
(Row_number() over (partition by customer_id order by time DESC) as rank
From  table 
Where rank <=2 
Inner join table t2 on table.customer_id  = t2. Customer_id and table.rank> tb2.rank

标签： sqlsql-serverrow-number