SELECT emp_num, years, SUM(salary) FROM sales
UNION ALL
SELECT emp_id, SUM(takehomepay)
FROM marketing
What error is present in the sample code above?
1. Queries being combined with the UNION ALL statement are
not allowed to have SELECT lists with a different number of
expressions.
2. You are not allowed to use aggregate functions within
two queries joined by a UNION ALL statement.
3. The UNION ALL statement incorrectly combines
the "years" result from the first query with the "SUM
(takehomepay)" result from the second query.
4. Unless the UNION ALL statement is replaced with a UNION
statement, the queries will return duplicates.
5. The "emp_id" column from the second query must be
renamed (or aliased) as "emp_num" so that it corresponds to
the column name from the first query. Otherwise, the
queries will not execute.
- 3 Answers
- 8932 Views
- I also Faced
- E-Mail Answers
Answer Posted / menan
Queries being combined with the UNION ALL statement are
not allowed to have SELECT lists with a different number of
expressions.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are different types of triggers?
How to use transactions efficiently : transact sql
What is nvarchar max in sql?
What is the purpose of the sql select top clause?
How to get unique records from a table?
What are user defined functions?
How many sectors are in a partition?
How to download oracle sql developer?
What is a column in a table?
Whis is not false in primary key?
What is the difference between clustered and non-clustered index in sql?
What packages(if any) has oracle provided for use by developers?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between having clause and where clause?
what are the different tables present in mysql? : Sql dba
