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

Answers were Sorted based on User's Feedback



in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |servi..

Answer / 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

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |servi..

Answer / vinay

friend i want o/p for multiple vehicle_no where service type
are different i.e paid ,first free,second free,third free
pls help

Is This Answer Correct ?    0 Yes 0 No

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |servi..

Answer / ajit nayak

select distinct vehicle_no, wm_concat( date )
from vehicle_service
group by vehicle_no;

Is This Answer Correct ?    0 Yes 0 No

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |servi..

Answer / vijay_1994

with temp as (select
service type,
paid,
vechile no,
dense_rank()over(order by date asc) as a
from table
select * from temp where a<=3;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are operators available in sql?

0 Answers  


What will you get by the cursor attribute sql%rowcount?

0 Answers  


What is a Procedure ?

3 Answers  


What are different types of sql?

0 Answers  


what are the advantages of sql ? : Sql dba

0 Answers  






What is difference between joins and union?

0 Answers  


What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  


what is explain plan?, given an example...

3 Answers   Polaris,


What is cursor in pl sql with examples?

0 Answers  


What is dense_rank?

0 Answers  


Can I join the same table twice?

0 Answers  


Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  


Categories