Which is faster subquery or join?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

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  

---

Does inner join return duplicate rows?

0 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

What is use of term?

0 Answers  

---

What is the difference between local variables and global variables?

0 Answers  

---

What is the difference between partition and index?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

Is stored procedure faster than query?

0 Answers  

---