Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

What is sql*plus?

0 Answers  

---

What is before and after trigger?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is dynamic query?

0 Answers  

---

what is unique key constraint? : Sql dba

0 Answers  

---

can we update a view which is created from two tables

11 Answers  

---

Explain what is table in a database?

0 Answers  

---

Can a foreign key be a duplicate?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What is hibernate and its relation to sql?

0 Answers  

---

Does db2 use sql?

0 Answers  

---