Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename
    (PortfolioNumber int, LevelCode int, AccountNumber varchar2(4), Status varchar2(6), track int)
;
INSERT ALL 
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 2, 'A101', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 2, 'A102', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 2, 'A103', 'Passed', 0)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 1, 'A101', 'Passed', 0)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 1, 'A102', 'Passed', 0)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 1, 'A103', 'Passed', 0)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 3, 'A101', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 3, 'A102', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (123, 3, 'A103', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (456, 1, 'A406', 'Failed', 1)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (456, 1, 'A407', 'Passed', 0)
    INTO tablename (PortfolioNumber, LevelCode, AccountNumber, Status, track)
         VALUES (456, 1, 'A408', 'Failed', 1)
SELECT * FROM dual
;
12 rows affected

select distinct PortfolioNumber, 
       min(LevelCode) over (partition by PortfolioNumber) LevelCode
from tablename
group by PortfolioNumber, LevelCode
having sum(track) > 0


PORTFOLIONUMBER
LEVELCODE


123
2

456
1


select * 
from tablename
where (PortfolioNumber, LevelCode) in (
  select distinct PortfolioNumber, 
         min(LevelCode) over (partition by PortfolioNumber) LevelCode
  from tablename
  group by PortfolioNumber, LevelCode
  having sum(track) > 0
)


PORTFOLIONUMBER
LEVELCODE
ACCOUNTNUMBER
STATUS
TRACK


123
2
A101
Failed
1

123
2
A102
Failed
1

123
2
A103
Passed
0

456
1
A406
Failed
1

456
1
A407
Passed
0

456
1
A408
Failed
1
PORTFOLIONUMBER	LEVELCODE	ACCOUNTNUMBER	STATUS	TRACK
123	2	A101	Failed	1
123	2	A102	Failed	1
123	2	A103	Passed	0
456	1	A406	Failed	1
456	1	A407	Passed	0
456	1	A408	Failed	1