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

[jy02206644]

如题，求一个方法，表结构
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不要重复就好，意思重复的内容取出一行就行，谢谢了

[liggway]

select distinct JOB_NO from T_SE_CONTAINER_CARGO

[hyrongg]

 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;

[csuxp2008]

[Quote=引用 2 楼 hyrongg 的回复:]
SQL code
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;
[/Quote]

UP！

[ren32408]

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;

支持2楼的写法！~