Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table ORDER_DETAIL
(ORDER_ID integer, 
ACTION_SEQUENCE integer, 
DETAIL_SEQUENCE integer, 
some_column varchar(100));
insert into order_detail values (314239027, 1, 1, 'foo');
1 rows affected

insert into order_detail values (314239027, 2, 2, 'bar');
1 rows affected

    SELECT * FROM ORDER_DETAIL
    WHERE (ORDER_ID, ACTION_SEQUENCE, DETAIL_SEQUENCE)
    IN (
        SELECT ORDER_ID, ACTION_SEQUENCE, DETAIL_SEQUENCE
        FROM ORDER_DETAIL
        WHERE ORDER_ID=314239027
    );


ORDER_ID
ACTION_SEQUENCE
DETAIL_SEQUENCE
SOME_COLUMN


314239027
1
1
foo

314239027
2
2
bar