怎么都喜欢贴个图上来,你给的代码想利用下都 不行啊SELECT T,L, max(decode(monthno,'20141206',H)), min(decode(monthno,'20141206',H)), max(decode(monthno,'20141206',H))-min(decode(monthno,'20141206',H)), ……--7、8号的参考上面写 from ……--后面和你的语句一样
不好意思 奉上代码 SELECT T, L, MIN(H) MIN, MAX(H) MAX, MAX(V) - MIN(V) V FROM (SELECT D.TEN T, D.LOCATION L, CONCAT(W.MONTHNO, W.HOURTIME) H, W.TOTALSTREAM V FROM D02WATERDATA W, B04DEVICE D WHERE W.B04ID = D.ID AND W.MONTHNO >= '20141206' AND W.MONTHNO <= '20141208' AND W.HOURTIME BETWEEN 030000 AND 050000) GROUP BY T, L ORDER BY T 你说的那个是固定的年月日 实际是条件查询 页面输入的该怎么弄?? 求指教!
max(decode(monthno,'20141206',H)),
min(decode(monthno,'20141206',H)),
max(decode(monthno,'20141206',H))-min(decode(monthno,'20141206',H)),
……--7、8号的参考上面写
from ……--后面和你的语句一样
奉上代码
SELECT T, L, MIN(H) MIN, MAX(H) MAX, MAX(V) - MIN(V) V
FROM (SELECT D.TEN T,
D.LOCATION L,
CONCAT(W.MONTHNO, W.HOURTIME) H,
W.TOTALSTREAM V
FROM D02WATERDATA W, B04DEVICE D
WHERE W.B04ID = D.ID
AND W.MONTHNO >= '20141206'
AND W.MONTHNO <= '20141208'
AND W.HOURTIME BETWEEN 030000 AND 050000)
GROUP BY T, L
ORDER BY T
你说的那个是固定的年月日 实际是条件查询 页面输入的该怎么弄?? 求指教!
AND W.MONTHNO <= '20141208'
这俩是条件 一般的情况下是问号查询 替换成 问号 怎么完善这个sql
可以考虑动态拼接语句,动态创建视图,然后select * from 视图得到结果
参考oracle行转列(动态行转不定列)