in sql table following column r there i want find 1st paid ,2nd paid,3rd paid d

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

4 Answers
5779 Views
I also Faced
E-Mail Answers

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

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers Virtusa,

Does SQL*Plus contains pl/sql Engine?

1 Answers TCS,

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers Satyam,

what is table? : Sql dba

0 Answers

How to select unique records from a table?

0 Answers

what are tables and fields? : Sql dba

0 Answers

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers iGate, Wipro,

What are the Restrictions on Cursor Variables?

2 Answers

write the Sql query for creating database backup?