By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table ATTR_TABLE (
USER_ID int,
ATTR_NAME varchar(20),
ATTR_VALUE varchar(20)
);
insert into ATTR_TABLE values
(1, 'Name', 'Jess'),
(1, 'Age', '23'),
(1, 'Sex', 'm'),
(2, 'Name', 'Jess'),
(2, 'Age', '23'),
(3, 'Name', 'Ann'),
(3, 'Sex', 'f');
Records: 7 Duplicates: 0 Warnings: 0
SELECT DISTINCT a1.USER_ID
FROM ATTR_TABLE a1
INNER JOIN ATTR_TABLE a2 ON a1.USER_ID = a2.USER_ID
WHERE
( a1.ATTR_NAME = 'Name' AND a1.ATTR_VALUE = 'Jess' )
AND ( a2.ATTR_NAME = 'Age' AND a2.ATTR_VALUE = '23' )
| USER_ID |
|---|
| 1 |
| 2 |