Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5901 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
What do we need to check in database testing?
Does mysql support pl sql?
Can we create a trigger on view?
What is attribute indicator in pl sql?
Is sqlite good enough for production?
How do you get column names only for a table (sql server)?
how to start mysql server? : Sql dba
What are the usages of sql?
What is a sql*loader control file?
How exception handling is done in advance pl/sql?
What is a primary key example?
What is difference between nchar and nvarchar?
what tools available for managing mysql server? : Sql dba
What is auto increment feature in sql?
What are pl/sql packages?
