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
- 5092 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
Where is all the data on the internet stored?
Does inner join return duplicate rows?
what is the difference between a having clause and a where clause? : Sql dba
What is a .db file?
What are the various restrictions imposed on view in terms of dml?
What is sql stand for?
Will truncate release space?
what is single byte over head in oracle..?
how to select unique records from a table? : Sql dba
Define a temp table?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is auto increment?
How do I audit the sql sent to the server?
What is rownum in sql?
define sql delete statement ? : Sql dba
