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
- 8933 Views
- I also Faced
- E-Mail Answers
Answer Posted / roopesh kumar
1. Queries being combined with the UNION ALL statement are
not allowed to have SELECT lists with a different number of
expressions.
Reason
Number of columns diff in both query.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the different parts of a package?
Write a sql select query that only returns each name only once from a table?
What is a left join?
What do you understand by case manipulation functions?
What is the difference between a primary key and a clustered index?
What is cursor explain with example?
How do you run a query?
What are schema-level triggers?
What is on delete set null?
What is procedure in pl sql?
Why we use pl sql?
How to select all records from the table?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
Explain ttitle and btitle.
What is meant by <> in sql?
