Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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 dynamic queries in t-sql? : Transact sql

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

What is ROWID?

8 Answers  

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

What is the difference between join and natural join?

0 Answers  

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

How do you remove duplicates without using distinct in sql?

0 Answers  

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories