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
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 is a sql instance vs database?
what are the drivers in mysql? : Sql dba
What is raid? How does it help storage of databases?
What is field delimiter?
Is sql developer case sensitive?
What is dml statement?
Explain sql data types?
How does an execution block start and end in pl sql?
What are the different datatypes available in PL/SQL?
Explain the types of joins in sql?
Which table is left in join?
explain mysql aggregate functions. : Sql dba
Is inner join same as self join?
What is java sql drivermanager?
What is nosql db?