为此创建一个新查询。 [英] create a new query for this.

问题描述

我想要这样的输出



我有一列表格

HI I want output like this

I have one column from the table

Date Time 
2013-12-17 14:41:00.000
2013-12-17 16:00:00.000
2013-12-17 16:29:00.000
2013-12-17 16:32:00.000
2013-12-17 17:54:00.000
2013-12-17 17:55:00.000

在第二列删除第一条记录

输出应该是这样的

in 2nd column remove first record
Output should be like this

Date Time                                NewDatetime          
2013-12-17 14:41:00.000                  2013-12-17 16:00:00.000
2013-12-17 16:00:00.000                  2013-12-17 16:29:00.000
2013-12-17 16:29:00.000                  2013-12-17 16:32:00.000
2013-12-17 16:32:00.000                  2013-12-17 17:54:00.000
2013-12-17 17:54:00.000                  2013-12-17 17:55:00.000
2013-12-17 17:55:00.000

使用第一列作为第二列，但在diff中第一行删除m第一列并将其用作新的日期时间栏



如何为此编写查询。



谢谢你，

use first column as a second column but in diff is first row remove from first column and use this as a new datetime column

How to write a query for this.

thank you ,

推荐答案

你好，



这应该可以帮到你。

Hi,

This should help you.

A.Datetime,B.Datetime 
from 
 (select   ROW_NUMBER() OVER (ORDER BY Datetime) AS RowNumber,Datetime1 from table1 ) AS A 
LEFT JOIN 
 (select   ROW_NUMBER() OVER (ORDER BY Datetime) AS RowNumber,Datetime1 from table1) AS B 
    ON B.RowNumber = A.RowNumber+1

如果有帮助，请将其标记为答案。

Please mark it as answer if it helps.

这篇关于为此创建一个新查询。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！