Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Query output

VPrasadApr 1 2024

with td as (
SELECT 17 ID, NULL NEXT_ID FROM DUAL UNION ALL
SELECT 15 ID, 17 NEXT_ID FROM DUAL UNION ALL
SELECT 15 ID, 16 NEXT_ID FROM DUAL UNION ALL
SELECT 14 ID, 15 NEXT_ID FROM DUAL UNION ALL
SELECT 10 ID, 14 NEXT_ID FROM DUAL UNION ALL
SELECT NULL ID, 12 NEXT_ID FROM DUAL)

SELECT * FROM TD;

I need to get only id is repeateD VALUES
15 17
15 16

Comments
Post Details
Added on Apr 1 2024
1 comment
65 views