SELECT *
FROM (SELECT t.*,
rank() over(partition by t.deptno order by t.sal) as num2
FROM emp t) ss
where 1 = 1
and ss.num2 = '1'
SELECT *
FROM (SELECT t.*,
rank() over(partition by t.deptno order by t.sal) as num2
FROM emp t) ss
where 1 = 1
and ss.num2 = '1'