Skip to content
Advertisement

What is the proper term for one of the disjuncts in a query using UNION?

Complete the sentence: In the query

the sub-selects SELECT 0 and SELECT 1 are properly known as the ___________s of the UNION.

I am not looking for your opinion on what would be a good name – I want you to back your answer up with a reference to some kind of authoritative source.

Advertisement

Answer

If I understand the Standard SQL document correctly this seems to be called <query term>.

It’s hard to find SQL:20xx online, Itzik Ben-Gan shows the relevant part in Fundamentals of table expressions

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement