mercredi 24 décembre 2014

select result max row in oracle express edition 11g


SELECT CALCULAR.START_TIME, CALCULAR.HORA, CALCULAR.PERIOD_MIN, CALCULAR.NE_NAME, CALCULAR.BSCRPT, CALCULAR.CALCULO_MAX FROM SMART2G.CALCULAR CALCULAR WHERE calculo_max = (SELECT MAX (calculo_max) FROM calcular WHERE CALCULAR.START_TIME BETWEEN TO_DATE ( '2014-11-19 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND TO_DATE ( '2014-11-19 23:00:00', 'yyyy/mm/dd hh24:mi:ss') AND CALCULAR.NE_NAME = 'PAN01BSC01') UNION ALL SELECT CALCULAR.START_TIME, CALCULAR.HORA, CALCULAR.PERIOD_MIN, CALCULAR.NE_NAME, CALCULAR.BSCRPT, CALCULAR.CALCULO_MAX FROM SMART2G.CALCULAR CALCULAR WHERE calculo_max = (SELECT MAX (calculo_max) FROM calcular WHERE CALCULAR.START_TIME BETWEEN TO_DATE ( '2014-11-19 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND TO_DATE ( '2014-11-19 23:00:00', 'yyyy/mm/dd hh24:mi:ss') AND CALCULAR.NE_NAME = 'PAN01BSC02') UNION ALL SELECT CALCULAR.START_TIME, CALCULAR.HORA, CALCULAR.PERIOD_MIN, CALCULAR.NE_NAME, CALCULAR.BSCRPT, CALCULAR.CALCULO_MAX FROM SMART2G.CALCULAR CALCULAR WHERE calculo_max = (SELECT MAX (calculo_max) FROM calcular WHERE CALCULAR.START_TIME BETWEEN TO_DATE ( '2014-11-19 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND TO_DATE ( '2014-11-19 23:00:00', 'yyyy/mm/dd hh24:mi:ss') AND CALCULAR.NE_NAME = 'PAN01BSC03' AND ROWNUM > 1 ) UNION ALL SELECT CALCULAR.START_TIME, CALCULAR.HORA, CALCULAR.PERIOD_MIN, CALCULAR.NE_NAME, CALCULAR.BSCRPT, CALCULAR.CALCULO_MAX FROM SMART2G.CALCULAR CALCULAR WHERE calculo_max = (SELECT MAX (calculo_max) FROM calcular WHERE CALCULAR.START_TIME BETWEEN TO_DATE ( '2014-11-19 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND TO_DATE ( '2014-11-19 23:00:00', 'yyyy/mm/dd hh24:mi:ss') AND CALCULAR.NE_NAME = 'PAN01BSC04') UNION ALL SELECT CALCULAR.START_TIME, CALCULAR.HORA, CALCULAR.PERIOD_MIN, CALCULAR.NE_NAME, CALCULAR.BSCRPT, CALCULAR.CALCULO_MAX FROM SMART2G.CALCULAR CALCULAR WHERE calculo_max = (SELECT MAX (calculo_max) FROM calcular WHERE CALCULAR.START_TIME BETWEEN TO_DATE ( '2014-11-19 00:00:00', 'yyyy/mm/dd hh24:mi:ss') AND TO_DATE ( '2014-11-19 23:00:00', 'yyyy/mm/dd hh24:mi:ss') AND CALCULAR.NE_NAME = 'PAN01BSC05')





Aucun commentaire:

Enregistrer un commentaire