What is the difference between UNION and UNION ALL?
Experience Level: Not defined
Tags: DatabasesSQL
Answer
Related Databases job interview questions
Describe and tell the difference amongst table, view and materialized view.
Databases Not definedCan you use different column names for tables merged using UNION ALL? What will be the column names in the result?
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 definedWhat is a result of the query below for table with 10 rows when there are 2 clients with the headcount column having a NULL value, there are 7 customers with 1 head and 1 customer with 2 heads?
DatabasesSQL Not defined