Select * from (
Select 1 as the flag, a. * from A
Union all
Select 2 as flag, a. * from A
)
Where flag=1

With
Select A. * from the efficiency of A same?

CodePudding user response:

, if the actual SQL exactly as you have written, but the question is why write?