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