SELECT *FROM (SELECT e.*, CASE WHEN (salary = MAX (salary) OVER (PARTITION BY t_id)) THEN 'Y' ELSE 'N' END AS max_num_idFROM employee e) DAT2WHERE max_num_id = 'Y';