display your age in months?

2 Answers  

---

What is on delete set null?

0 Answers  

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

how many no of table can be join in a sql query.

4 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

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  

---

How many types of primary keys are there?

0 Answers  

---

What is difference between pl and sql?

0 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---

Where is sql database stored?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---