friend i want o/p for multiple vehicle_no where service type are different

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

Question Posted / vinay

4 Answers
5726 Views
I also Faced
E-Mail Answers

Answer Posted / vinay

friend i want o/p for multiple vehicle_no where service type
are different i.e paid ,first free,second free,third free
pls help

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle pl sql developer?

932

Can we use delete in merge statement?

999

How do I view a view in sql?

888

Is record in oracle pl sql?

901

What are the different tcl commands in sql?

1102

what is oltp (online transaction processing)? : Sql dba

1011

How do I delete a trigger?

911

how to do backup entire database? : Transact sql

1066

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1039

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1111

What is the difference between truncate and drop statements?

1081

what are the differences between char and nchar? : Sql dba

1054

How do I remove sql developer from windows 10?

1011

What is sap sql anywhere?

969

How do I run a sql script?

1051