Good morning, I need some help for a query.
The result I want to achieve is to show all duplicate values with a given data.
Here is some example data:
CREATE TABLE DOCUMENT (
DOCUMENT_GID varchar(255),
DOCUMENT_DEF_GID varchar(255),
OWNER_OBJECT_GID varchar(255)
);
INSERT INTO DOCUMENT (DOCUMENT_GID, DOCUMENT_DEF_GID, OWNER_OBJECT_GID)
VALUE ('DOCUMENT1', 'RSK.EXTERNAL ATTACHMENT', 'RSK.2206080010');
INSERT INTO DOCUMENT (DOCUMENT_GID, DOCUMENT_DEF_GID, OWNER_OBJECT_GID)
VALUE ('DOCUMENT2', 'RSK.EXTERNAL ATTACHMENT', 'RSK.2206080010');
INSERT INTO DOCUMENT (DOCUMENT_GID, DOCUMENT_DEF_GID, OWNER_OBJECT_GID)
VALUE ('DOCUMENT3', 'FFC', 'RSK.2206080010')
The duplicate values we are trying to find is in the column: Document_def_gid with the value: RSK.EXTERNAL_ATTACHMENT
Therefore, these should only be shown at the time when the value RSK.EXTERNAL_ATTACHMENT is duplicated with an OWNER_OBJECT_GID.
We want to adjust this double value, so when 2 lines are double 1 line may be visible. when 3 lines are double 2 lines may be visible and so on.
the query currently being used to see all rules:
select document_gid, document_def_gid, owner_object_gid from document WHERE DOCUMENT_DEF_GID = 'RSK.EXTERNAL ATTACHMENT'