Select 编号,(Select 电表读数 from tableName where 抄表日期 = (Select max(抄表日期) from tableNmae where 抄表日期<= @rq2)) - (Select 电表读数 from tableName where 抄表日期 = (Select min(抄表日期) from tableNmae where 抄表日期>= @rq1))
from tableName
Select
(Select 电表读数 Form Table Where 抄表日期 = '2001.01.02 14:30:00'
Where 电表号=‘XXX’) A
-
(Select 电表读数 Form Table Where 抄表日期 = '2000.12.31 14:30:00'
Where 电表号=‘XXX’) B
Oracle:
Select
(Select 电表读数 Form Table Where 抄表日期 = '2001.01.02 14:30:00'
Where 电表号=‘XXX’) A
-
(Select 电表读数 Form Table Where 抄表日期 = '2000.12.31 14:30:00'
Where 电表号=‘XXX’) B
Select 编号,(Select 电表读数 from tableName where 抄表日期 = (Select max(抄表日期) from tableNmae where 抄表日期<= @rq2)) - (Select 电表读数 from tableName where 抄表日期 = (Select min(抄表日期) from tableNmae where 抄表日期>= @rq1))
from tableName