create table BANDWIDTHPOWER
(
DATETIME date not null,
DESCONTENT NUMBER(10),
FVALUE NUMBER(10) not null,
TS0AVGDISTURBPOW NUMBER(10),
TS0AVGBANDWIDTHPOW NUMBER(10)
}
现在需要求在一个时间段内,TS0AVGDISTURBPOW和TS0AVGBANDWIDTHPOW的最大值,
并求此段时间内,最近的那个时间的DESCONTENT值?如何写sql?
(
DATETIME date not null,
DESCONTENT NUMBER(10),
FVALUE NUMBER(10) not null,
TS0AVGDISTURBPOW NUMBER(10),
TS0AVGBANDWIDTHPOW NUMBER(10)
}
现在需要求在一个时间段内,TS0AVGDISTURBPOW和TS0AVGBANDWIDTHPOW的最大值,
并求此段时间内,最近的那个时间的DESCONTENT值?如何写sql?
解决方案 »
- 求问一个关于exists的问题
- oracle 存储过程 入参为游标
- Linux shmmax和ORACLE 的sga
- ORACLE里可以这么写吗?insert into tablename values('col1','col2'),('col11','col22')
- 一个简单的java调用oracle 函数试题,求高手指点
- 想换用户登陆
- 如何用一条语句查询前N条最大的记录
- 两张表做联结,怎么才能查询第m到第n条的记录啊
- 有奖:寻人启事,谁能帮我找到“ebrowser(鹏鹏) ”,有急事,谢谢
- 这条sql语句可能写出来吗?
- 请教高手。。为什么我用IPM导入一个DMP后数据库就无法打开。。
- [学习] 求存储过程
select max(TS0AVGDISTURBPOW),max(TS0AVGBANDWIDTHPOW) from BANDWIDTHPOWER
where Datetime between d1 and d2;select descontent from BANDWIDTHPOWER
where datetime=( select max(Datetime) from bandwidthpower
where datetime between d1 and d2);
from BANDWIDTHPOWER where datetime=( select max(Datetime) from bandwidthpower
where datetime between d1 and d2))
from BANDWIDTHPOWER
where Datetime between d1 and d2;
我怎么不行啊,怀疑中....
你写的根本不行啊。我倒
from BANDWIDTHPOWER where datetime=( select max(Datetime) from bandwidthpower
where datetime between d1 and d2 =×select max(TS0AVGDISTURBPOW),max(TS0AVGBANDWIDTHPOW),(×)
from BANDWIDTHPOWER
where Datetime between d1 and d2;有这样套用的啊?晕死,根本不可以的
2 (select datetime,b,c,
3 (select a from test where datetime=
4 (select max(datetime) from test where
5 datetime between sysdate-5 and sysdate-2)) a
6 from test) table1
7 where table1.datetime between sysdate-5 and sysdate; MAX(B) MAX(C) MAX(A)
---------- ---------- ----------
20 52 2SQL> select * from test;DATETIME A B C
---------- ---------- ---------- ----------
26-7月 -05 1 1 1
25-7月 -05 2 2 2
24-7月 -05 5 20 2
23-7月 -05 3 10 52
22-7月 -05 7 6 8SQL>
max(TS0AVGBANDWIDTHPOW) over(),
first_value(DESCONTENT) over(order by DATETIME)
from BANDWIDTHPOWER
where DATETIME between ...and ...
max(TS0AVGBANDWIDTHPOW) over(),
first_value(DESCONTENT) over(order by DATETIME desc)
from BANDWIDTHPOWER
where DATETIME between ...and ...