Values

  -- values : to create a table on the fly !

select * from test10 where (num1,num2, num3) in
(values( 1, 2, 3), (3, 4, 4));

select * from (values ( 1, 2, 3), (3, 4, 4))  as t; 

values ( 1, 2, 3), (3, 4, 4);

 
values 123, 456, 789;

insert into test10
values (5, 5, 5), (6, 5, 4), (7, 4, 1), (2, 4, 8), (3, 6, 9);