根据max(时间)和min(时间)减去数据 [英] subtract data according to max(time) and min(time)

问题描述

我在sqlserver2008中创建了一个表，该表具有2列数据作为浮点数和时间作为时间戳，并且我必须进行计算
(数据@时间结束–数据@时间开始)

i''d created a table with 2 column data as float and time as timestamp in sqlserver2008 and i ve to calculate
(data @ end of time – data @ beginning of time)

推荐答案

啊！好多了！
因此，您有一个包含两列的表，并且想要查找时间段的开始和结束并返回最旧和最新日期的两个数据值之间的差?
试试:

Ah! That''s a bit better!
So you have a table with two columns, and you want to find the start and end of a period and return the difference between the two data values on the oldest and latest dates?
Try:

SELECT
   (SELECT TOP 1 data FROM myTable ORDER BY [time] DESC) -
   (SELECT TOP 1 data FROM myTable ORDER BY [time] ASC)

我自己解决了这个问题，这是我的问题sql查询

I solved that by myself and this is my sql query

select Q1.A1-Q2.A2,Q1.B1 FROM(SELECT F.A A1,F.B AS B1,C FROM (SELECT MAX(B) MA,MIN(B) MI,C FROM(SELECT A,B,TO_CHAR(B,'DD/MM/YY HH') C FROM FIND_TIME) GROUP BY C) E,FIND_TIME F WHERE E.MA=F.B) Q1,(SELECT F.A A2,F.B AS B2,C FROM (SELECT MAX(B) MA,MIN(B) MI,C FROM(SELECT A,B,TO_CHAR(B,'DD/MM/YY HH') C FROM FIND_TIME) GROUP BY C) E,FIND_TIME F WHERE E.MI=F.B) Q2
WHERE Q1.C=Q2.C;

DATA列为A，Time列为B

DATA Column as A and Time column as B

这篇关于根据max(时间)和min(时间)减去数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！