oracle查询表中某个字段不重复的记录方法

表结构
CREATE TABLE T_SE_CONTAINER_CARGO
(
  CONTAINER_NO  VARCHAR2(64 BYTE),
  CARGO_ID      NUMBER(12)                      NOT NULL,
  QUANTITY      NUMBER(9),
  GROSS_WEIGHT  NUMBER(12,4),
  MEASUREMENT   NUMBER(12,4),
  JOB_NO        NUMBER(12)                      NOT NULL,
  SEAL_NO       VARCHAR2(64 BYTE)               NOT NULL
)
字段是JOB_NO，因为JOB_NO为非唯一字段，会有重复记录，想查询出来的内容字段JOB_NO不要重复

 select * from (
 select CONTAINER_NO,
    CARGO_ID,      
    QUANTITY,      
    GROSS_WEIGHT,  
    MEASUREMENT,  
    JOB_NO,         
    SEAL_NO,Row_number()over(partition by job_no order by job_no) rn
  from T_SE_CONTAINER_CARGO
) tmp where rn=1;