what is the difference between where clause and having clause? : 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  

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

What is the use of triggers?

0 Answers  

---

What are inner outer left and right joins in sql?

0 Answers  

---

---

What is magic table?

6 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

Why use stored procedures?

0 Answers  

---

What is sql indexing?

0 Answers  

---