Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create Table ATTRIBUTE_TAB(ID INT, ATTRIBUTE VARCHAR(50), VALUE_NO INT, VALUE_TEXT VARCHAR(50));
Insert All Into ATTRIBUTE_TAB Values(1,'WIDTH',6000,NULL)
Into ATTRIBUTE_TAB Values(1,'COLOR', NULL,'BLUE')
Into ATTRIBUTE_TAB Values(1,'GLASS', NULL,'TEMPERED')
Into ATTRIBUTE_TAB Values(2,'WIDTH',5000,NULL)
Into ATTRIBUTE_TAB Values(2,'COLOR', NULL,'BLUE')
Into ATTRIBUTE_TAB Values(2,'GLASS', NULL,'TEMPERED')
Into ATTRIBUTE_TAB Values(3,'WIDTH',5000,NULL)
Into ATTRIBUTE_TAB Values(3,'COLOR', NULL,'RED')
Into ATTRIBUTE_TAB Values(3,'GLASS', NULL,'TEMPERED')
Select 1 From DUAL;
9 rows affected

SELECT * FROM ATTRIBUTE_TAB
  WHERE ID IN
  (
    SELECT ID FROM ATTRIBUTE_TAB
    WHERE VALUE_NO='6000' OR VALUE_TEXT='TEMPERED'OR VALUE_TEXT='BLUE'
    GROUP BY ID
    HAVING COUNT(*) = 3
  )
ORDER BY ID, ATTRIBUTE DESC


ID
ATTRIBUTE
VALUE_NO
VALUE_TEXT


1
WIDTH
6000
null

1
GLASS
null
TEMPERED

1
COLOR
null
BLUE


SELECT * FROM ATTRIBUTE_TAB
  WHERE ID IN
  (
    SELECT ID FROM ATTRIBUTE_TAB
    WHERE VALUE_NO='6000' OR VALUE_TEXT='TEMPERED'OR VALUE_TEXT='BLUE'
    GROUP BY ID
    HAVING COUNT(DISTINCT ATTRIBUTE) = 3
  )
ORDER BY ID, ATTRIBUTE DESC


ID
ATTRIBUTE
VALUE_NO
VALUE_TEXT


1
WIDTH
6000
null

1
GLASS
null
TEMPERED

1
COLOR
null
BLUE