FREE AI-Enhanced Online Oracle Compiler

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE my_table (
    A NUMBER,
    Group_B NUMBER,
    Value_C NUMBER,
    Value_D NUMBER
);

INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (1, 10, 100, 1000);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (2, 11, 100, 1001);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (3, 12, 101, 1002);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (4, 13, 102, 1003);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (5, 14, 103, 1004);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (6, 14, 103, 1005);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (7, 14, 103, 1006);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (8, 15, 104, 1007);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (9, 16, 105, 1008);
INSERT INTO my_table (A, Group_B, Value_C, Value_D) VALUES (10, 16, 105, 1009);

select * 
from my_table 
where Value_C in (
  	select Value_C
    from my_table
    group by Value_C
    having count(Value_C) > 1 and max(Group_B)<> min(Group_B)
)  
and Value_D is not null 
order by Value_C;

A	GROUP_B	VALUE_C	VALUE_D
2	11	100	1001
1	10	100	1000