Explain what is a view?

0 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,

---

Can you do multiple joins in sql?

0 Answers  

---

What is the full form of sql?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

What is sql dialect?

0 Answers  

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

---

What are the uses of merge?

0 Answers  

---