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
- 8362 Views
- I also Faced
- E-Mail Answers
Answer Posted / tulsi
1)query block has incorrect number of result columns
error displayed will be displayed
2)The group by expressions are missing
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are commit, rollback, and savepoint?
Why we use sql profiler?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How to assign sql query results to pl sql variables?
What is the life of an sql statement?
what is column? : Sql dba
What are all the different normalizations?
How do you respond to dementia behavior?
Where not exists in sql?
which types of join is used in sql widely? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Define union, minus, union all, intersect ?
Does db2 use sql?
What are the types of join and explain each?
What does count (*) do in sql?
