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
- 9730 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 different categories of sql commands?
How many row comparison operators are used while working with a subquery?
Why is sql better than hql?
What are different types of keys?
Can you select everything, but 1 or 2 fields, without writer's cramp?
How do you remove duplicate records from a table?
how do you tune the slow running queries in oracle db , explain the methodology
What is sql analyzer?
What do you mean by field in sql?
What are keys in sql?
What is row_number () in sql?
What are the string functions in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is trigger in flip flop?
What is meant by user defined function?
