By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable
(`pnom` int, `ocinka` int, `snom` int)
;
INSERT INTO mytable
(`pnom`, `ocinka`, `snom`)
VALUES
(2, 3, 6),
(3, 4, 1),
(3, 4, 1),
(3, 2, 6),
(3, 5, 3),
(3, 3, 7),
(3, 3, 7),
(4, 5, 3)
;
Records: 8 Duplicates: 0 Warnings: 0
WITH unwanted as (SELECT DISTiNCT `snom` FROM mytable WHERE `ocinka` = 3 AND `pnom` = 3)
SELECT DISTINCT `snom` FROM mytable WHERE `pnom` = 3 AND `snom` NOT IN (SELECT `snom` FROM unwanted)
| snom |
|---|
| 1 |
| 6 |
| 3 |