CODEWITHSUNDEEP
sqloracle-databaseselectview
Symonds
Symonds

Reputation: 194

Apply filter in Oracle View

I have below view where i just wanted to apply small filter such that for example i want to ignore or remove all rows for each IDENTIFIER from the View where member_descr = 'O' and member_ratio < = -5.

I am not sure if i want to create new Union condition or apply filter where i am calculating value for member_ratio value for member_descr = 'O'

Currently in the fiddle we can see the member_ratio value is 15.32778 for member_descr = 'O' which is ok for Identifier I0000RTERER3 after calculation. But after calculation for member_descr = 'O' if the member_ratio <= -5 then i want to ignore or remove all the rows for this identifier from view.

Upvotes: 1

Views: 585

Answers (1)

Sujitmohanty30
Sujitmohanty30

Reputation: 3316

If I understood now we need not exists here,

select * 
  from IS_ID t1
  where not exists ( select 1
                       from IS_ID t2
                      where t1.identifier = t2.identifier
                        and (MEMBER_DESCR = 'O' and member_ratio < -5))

Upvotes: 1

Related Questions