這麼一條sql SELECT tt , nn , cc FROM ( SELECT A.tt , B.nn , C.cc , RANK() OVER (PARTITION BY C.ff, C.gg ORDER BY C.hh) AS R