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
- 5099 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
How to assign sql query results to pl sql variables?
What is oracle and pl sql?
what are different types of collation sensitivity? : Sql dba
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
How many types of normalization are there?
what is sql profiler? : Sql dba
How do I remove sql developer from windows 10?
How we can update the view?
Are left and right joins the same?
What are tables in sql?
What are the three forms of normalization?
How to prepare for oracle pl sql certification?
What is the difference between null value, zero, and blank space?
what are set operators in sql? : Sql dba
explain advantages of myisam over innodb? : Sql dba
