DEFINITION :- Set operation are used to combine the result(rows) of two or more select queries into a single result . unlike the join where we needed the key col here ...
below is a use demo: Connect to SQL Server, create a table dbo.OrderDetail, and run some sql on this table.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results