Skip to Main Content

SQL- PL&SQL

User_A3XIHDec 26 2022

i've prepared a case, but I want to filter the A part.I don't want the "others" ones to come.
"Case when......
when GROUP(OX)='T0' AND DAYS>30 THEN 'ANSWERS' ELSE 'OTHERS' END A"

i mean, how do I filter with having?
HAVING NOT IN GROUP='OTHERS';
─░ts not working :(

Comments
Post Details
Added on Dec 26 2022
4 comments
44 views