select distinct service_type,date,vehicle_no 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 / sudipta santra

4 Answers
5734 Views
I also Faced
E-Mail Answers

Answer Posted / sudipta santra

select distinct service_type,date,vehicle_no from
vehicle_service
where vehicle_no='MH12H2007' and service_type='paid' and
rownum<4
order by date desc

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we store rows in PL/SQL using array?

1162

What is use of term?

1009

What is schema in sql?

887

What is pl sql package?

993

How is debugging done?

921

Explain what is sql*plus?

1087

Is sql better than excel?

1062

What is the difference between sql and t sql?

966

Can we insert data into view?

850

Can a procedure in a package be overloaded?

984

How do you use a while loop in pl sql?

942

Can we use views in stored procedure?

972

what is a database? : Sql dba

1101

What are the types of optimization?

889

What are the types of functions in sql?

968