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
- 6027 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
how to use myisamchk to check or repair myisam tables? : Sql dba
how would you enter characters as hex numbers? : Sql dba
what is online transaction processing (oltp)? : Sql dba
What are sql*plus environment variables?
What is pivot in sql?
Which are the different character-manipulation functions in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
How do I copy a table in sql?
How do you determine the current isolation level? : Transact sql
How do you delete data from a table?
What is sql injection vulnerability?
What are the properties of a transaction?
what is 'mysqlimport'? : Sql dba
What is a data definition language?
what are tables and fields? : Sql dba
