Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9571 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
Why do we use view in sql?
how to rename an existing column in a table? : Sql dba
How to return an array from java to pl/sql?
Why do we go for stored procedures?
what are all the different normalizations? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is information schema in sql?
What are the types of subqueries?
what is subquery? : Sql dba
how to convert numeric values to character strings? : Sql dba
How to avoid duplicate records in a query?
Is sql the best database?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What does over partition by mean in sql?
How do I run a sql trace?
