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  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

what is an alias command? : Sql dba

0 Answers  

---

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

---

What are the types of operators available in sql?

0 Answers  

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

Can we perform dml on view?

0 Answers  

---

Why is theta join required?

0 Answers  

---

Is time a data type in sql?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

what is column? : Sql dba

0 Answers  

---