select distinct vehicle_no, wm_concat( date ) from vehicle

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

Question Posted / ajit nayak

4 Answers
5731 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

Please Help Members By Posting Answers For Below Questions

What are the two parts of design view?

973

What is pl sql package?

991

Why is nosql good?

976

What is a trigger in sql?

1157

Can ddl statements be used in pl/sql?

1068

Explain what is sql*plus?

1084

What is crud stand for?

931

Explain alias in sql?

993

what is try_catch block in procedure

1656

Can we use rowid as primary key?

941

What is the limitation on the block size of pl/sql?

936

What is the use of function in sql?

1027

What are the steps for performance tuning.

1268

How to rename a column in the output of sql query?

1000

What is trigger types in sql?

942