The table structure is like this;
Table - 1
PROCESS_DATE|CLEARING_DATE|BATCH_NO|SLIP_NO|DOC_TYPE|CHEQUE_NO|UNIQUE_IDENTIFIER
2020-02-22|2020-02-25|7135001-000850|1|3|251088|2020022571350010008500001
2020-02-22|2020-02-25|7135001-000850|1|3|012057|2020022571350010008500002
2020-02-22|2020-02-25|7135001-000850|1|3|000093|2020022571350010008500003
2020-02-22|2020-02-25|7135001-000850|1|3|389389|2020022571350010008500004
2020-02-22|2020-02-25|7135001-000850|1|3|679492|2020022571350010008500005
2020-02-22|2020-02-25|7135001-000850|2|3|389323|2020022571350010008500006
2020-02-22|2020-02-25|7135001-000850|2|3|012062|2020022571350010008500007
2020-02-22|2020-02-25|7135001-000850|2|3|679504|2020022571350010008500008
2020-02-23|2020-02-25|7135001-000850|2|3|389323|2020022571350010008500006
2020-02-23|2020-02-25|7135001-000850|2|3|012062|2020022571350010008500007
Table - 2
PROCESS_DATE|CLEARING_DATE|BATCH_NO|SLIP_NO|DOC_TYPE|CHEQUE_NO|UNIQUE_IDENTIFIER
2020-02-22|NULL|7135001-000850|1|2|NULL|2020022271350010008500001
2020-02-22|NULL|7135001-000850|2|2|NULL|2020022271350010008500002
2020-02-23|NULL|7135001-000850|2|2|NULL|2020022371350010008500002
2020-02-25|NULL|7135001-000850|1|2|NULL|2020022571350010008500001
2020-02-25|NULL|7135001-000850|2|2|NULL|2020022571350010008500002
Out put i need
PROCESS_DATE|CLEARING_DATE|BATCH_NO|SLIP_NO|DOC_TYPE|CHEQUE_NO|UNIQUE_IDENTIFIER
2020-02-22|NULL |7135001-000850|1|2|NULL |2020022271350010008500001
2020-02-22|2020-02-25|7135001-000850|1|3|251088|2020022571350010008500001
2020-02-22|2020-02-25|7135001-000850|1|3|012057|2020022571350010008500002
2020-02-22|2020-02-25|7135001-000850|1|3|000093|2020022571350010008500003
2020-02-22|2020-02-25|7135001-000850|1|3|389389|2020022571350010008500004
2020-02-22|2020-02-25|7135001-000850|1|3|679492|2020022571350010008500005
2020-02-22|NULL |7135001-000850|2|2|NULL |2020022271350010008500002
2020-02-22|2020-02-25|7135001-000850|2|3|389323|2020022571350010008500006
2020-02-22|2020-02-25|7135001-000850|2|3|012062|2020022571350010008500007
2020-02-22|2020-02-25|7135001-000850|2|3|679504|2020022571350010008500008
2020-02-23|NULL |7135001-000850|2|2|NULL |2020022371350010008500002
2020-02-23|2020-02-25|7135001-000850|2|3|389323|2020022571350010008500006
2020-02-23|2020-02-25|7135001-000850|2|3|012062|2020022571350010008500007
0
What I have tried:
SELECT * FROM (
SELECT
PROCESS_DATE,
CLEARING_DATE,
BATCH_NO,
SLIP_NO,
DOC_TYPE,
CHEQUE_NO,
AMOUNT,
UNIQUE_IDENTIFIER,
COUNT(*) OVER (PARTITION BY PROCESS_DATE,SLIP_NO ) AS RN
FROM
(
SELECT
PROCESS_DATE,
CLEARING_DATE,
BATCH_NO,
SLIP_NO,
DOC_TYPE,
CHEQUE_NO,
AMOUNT,
UNIQUE_IDENTIFIER
FROM IMG_PDC_OUTWARDCLEARING
WHERE 1=1
AND CLEARING_DATE='2020-02-25'
AND BATCH_NO='7135001-000850'
AND DOC_TYPE=3
UNION
SELECT
PROCESS_DATE,
CLEARING_DATE,
BATCH_NO,
SLIP_NO,
DOC_TYPE,
CHEQUE_NO,
AMOUNT,
UNIQUE_IDENTIFIER
FROM IMG_PDC_OUTWARDCLEARING
WHERE 1=1
AND BATCH_NO='7135001-000850'
AND DOC_TYPE=2
)Y )Z WHERE Z.RN <> 1
ORDER BY
PROCESS_DATE ASC,
CLEARING_CYCLE ASC,
BATCH_NO ASC,
SLIP_NO ASC,
CLEARING_DATE ASC,
SEQ_NO ASC,
UNIQUE_IDENTIFIER ASC