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
- 9473 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 is a data definition language?
What is loop in pl sql?
How can a function retun more than one value in oracle with proper example?
What is the current version of postgresql?
What is before and after trigger?
What is the difference between an inner and outer join?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What does cursor do in sql?
What are synonyms in sql?
how many values can the set function of mysql take? : Sql dba
Can a composite key be null?
Does pl/sql support create command?
What are the two types of exceptions in pl/sql?
Why commit is not used in triggers?
How many disk partitions should I have?
