SELECT * FROM ( SELECT MIN(a) AS a, b, MIN(c) AS c FROM tb WHERE b=1 UNION SELECT NULL, NULL, c FROM tb WHERE b=1 AND c>(SELECT MIN(c) FROM tb WHERE b=1) ) xx ORDER BY c
select decode(rn,1,a,'') a,decode(rn,1,b,'') b,c from(select row_number()over(partition by a,b order by c) rn,a,b,c from tb)
SELECT decode(row_number() over(partition by a,b order by a,b),1,a,'') a, decode(row_number() over(partition by a,b order by a,b),1,b,'') b, c FROM tb
FROM (
SELECT MIN(a) AS a, b, MIN(c) AS c
FROM tb
WHERE b=1
UNION
SELECT NULL, NULL, c
FROM tb
WHERE b=1
AND c>(SELECT MIN(c) FROM tb WHERE b=1)
) xx
ORDER BY c
from(select row_number()over(partition by a,b order by c) rn,a,b,c from tb)
decode(row_number() over(partition by a,b order by a,b),1,b,'') b,
c
FROM tb