Can you use different column names for tables merged using UNION ALL? What will be the column names in the result?
Experience Level: Not defined
Tags: DatabasesSQL
Answer
Related Databases job interview questions
How would you store 1 million phone numbers?
Data StructuresDatabases Not definedDescribe and tell the difference amongst table, view and materialized view.
Databases Not definedWhat is the difference between UNION and UNION ALL?
DatabasesSQL Not definedWhat is the processing order of logical parts of the following query?
DatabasesSQL Not definedWhen you use SQL Server, what is a difference between local and global temporary table?
DatabasesMS SQL ServerSQL Not defined