Where not exists in sql?

0 Answers  

---

What is t sql in sql server?

0 Answers  

---

What is sql keyword?

0 Answers  

---

What is secondary key?

0 Answers  

---

Can you do multiple joins in sql?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

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  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

How can you load multi line records? : aql loader

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

How is debugging done?

0 Answers  

---