How to get time difference between 30th and 50th row in SQL Server

Hi mohdImran,

Refer the below query.

SELECT DATEDIFF(MINUTE, '2016-07-27 18:46:34.000', '2016-07-27 18:45:09.000') AS timedifference

OutPut

timedifference

      -1

SQL

DECLARE @Test AS TABLE (TimeRecorded DATETIME)
INSERT INTO @Test VALUES('2016-07-27 18:44:21.000') 
INSERT INTO @Test VALUES('2016-07-27 18:44:31.000') 
INSERT INTO @Test VALUES('2016-07-27 18:44:39.000') 
INSERT INTO @Test VALUES('2016-07-27 18:44:41.000') 
INSERT INTO @Test VALUES('2016-07-27 18:44:52.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:02.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:09.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:12.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:22.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:33.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:40.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:43.000') 
INSERT INTO @Test VALUES('2016-07-27 18:45:53.000') 
INSERT INTO @Test VALUES('2016-07-27 18:46:04.000') 
INSERT INTO @Test VALUES('2016-07-27 18:46:10.000') 
INSERT INTO @Test VALUES('2016-07-27 18:46:14.000') 
INSERT INTO @Test VALUES('2016-07-27 18:46:24.000') 
INSERT INTO @Test VALUES('2016-07-27 18:46:34.000') 

DECLARE @FromRow INT , @ToRow INT
SET @FromRow = 5
SET @ToRow = 18

DECLARE @5thRowDate DATETIME
SET @5thRowDate = (SELECT TimeRecorded FROM (SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS RowNo,TimeRecorded FROM @Test) t) t1 WHERE RowNo = @FromRow)

DECLARE @18thRowDate DATETIME
SET @18thRowDate = (SELECT TimeRecorded FROM (SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS RowNo,TimeRecorded FROM @Test) t) t1 WHERE RowNo = @ToRow)

SELECT DATEDIFF(MINUTE, @5thRowDate, @18thRowDate) AS timedifference

Output

timedifference

       2

Here i have shown you the time difference between 5th record and 18th record in minutes.