SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp

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.

Question Posted / suresh

3 Answers
9634 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM mark..

Answer / 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

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM mark..

Answer / 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

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM mark..

Answer / 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

More SQL PLSQL Interview Questions

What is $$ in sql?

0 Answers

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers Sonata,

what are aggregate and scalar functions? : Sql dba

0 Answers

What is difference between sql and oracle?

0 Answers

select top 3 sal from each dept?

17 Answers IBM, TCS,

How do you write a subquery?

0 Answers

Which are the different types of indexes in sql?

0 Answers

What is a package ? What are the advantages of packages ?