query in table in BD oracle with internal clauses

Navigation
0

HELLO,  I want to make a query in ORACLE that brings me all the scores that are lower than 3.0 (YELLOW) but not of those that have the same DERA_FKREGISTROACTIVIDAD and in some have a score higher than 3.0, the blues have a score less than 3 but there is another DERA_FKREGISTROACTIVIDAD that has a score much higher than 3.0

that is to say, to bring the records in which they do not allan past and those that if not consult them

IN ADVANCE THANK YOU.

    
asked by Duban Ortiz 30.05.2018 в 23:14
source

1 answer

0

I RESOLVED IT IN THE FOLLOWING FORM 

SELECT COUNT(*), MAX(DERA_PUNTAJE), DERA_FKREGISTROACTIVIDAD FROM CAPACITACIONES.DETALLEREGISTROACTIVIDAD GROUP BY DERA_FKREGISTROACTIVIDAD SOLO ES CUESTIÓN DE IMAGINACIÓN
    
answered by 31.05.2018 в 22:25
Select in SQL the current date and time of the assigned time zone even if the user changes the date of the S.O. Multiply 2 Columns and Add to the MYSQL End