What is the difference between cross join and natural join?

0 Answers  

---

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

---

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  

---

how to fetch common records from two tables? : Sql dba

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

Compare sql & pl/sql

0 Answers  

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

How do you respond to dementia behavior?

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

What is record data type?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---