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
- 4805 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select distinct vehicle_no, wm_concat( date )
from vehicle_service
group by vehicle_no;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are dml commands?
What is dbo in sql?
explain commit and rollback in mysql : sql dba
what is recursive stored procedure? : Sql dba
How much does a sql dba make? : SQL DBA
Explain the types of joins in sql?
When are we going to use truncate and delete?
what is a table in a database ? : Sql dba
What are packages in pl sql and also explain its advantages?
How do I view a sql database?
What are its different types of dbms?
What is asqueryable?
Can %notfound return null after a fetch?
what are integrity rules?
What is constant in pl sql?
