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
- 9618 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 is difference between inner join and self join?
what is oracle database ? : Sql dba
Why is theta join required?
Why use truncate instead of delete?
what is a trigger? : Sql dba
What is the best partition size for windows 10?
What are the properties of a transaction?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is meant by user defined function?
How to read/write files from pl/sql?
Can I call a procedure inside a function?
Can dml statements be used in pl/sql?
How many times can we commit in a loop?
What does cursor do in sql?
Differentiate between % rowtype and type record.
