SELECT
    g.COLUMN1,
    g.COLUMN2,
    e.COLUMN3,
    g.COLUMN4, 
    MIN(e.dat1) KEEP ( DENSE_RANK FIRST ORDER BY date2 Desc) * -1,
    min(to_char(date3,'dd-mm-yyyy'))
from table1 e, table2 g 
    where 
    ( 
        e.COLUMN3 in 
        ( 
            select COLUMN3 from table1 
            where 
            date2 =( to_date(?SVAR,'DD-MM-YYYY') - (?SVAR + 1 )) 
            and dat1 >= 0 and column6 = ?SVAR 
        ) 
        OR         
        e.COLUMN3 in 
        (
            select COLUMN3 from table1 having min(date3) = (to_date(?SVAR,'DD-MM-YYYY') - (?SVAR)) group by COLUMN3
        ) 
    )  
    and date3 >=  (to_date(?SVAR,'DD-MM-YYYY') - ?SVAR) 
    and g.column6 = e.column6   
    and e.column6 = ?SVAR 
    and g.COLUMN3 = e.COLUMN3 
    and (g.column7 = 'SBA' or g.column7 = 'CAA') 
    and g.column8 = ?SVAR
    and g.column9 = ?SVAR
    and g.column10 = ?SVAR 
    having max(dat1) <0 
    group by g.COLUMN1,g.COLUMN2,e.COLUMN3,g.COLUMN4

min(to_char(date3,'dd-mm-yyyy'))