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
- 4 Answers
- 4496 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
How do I view a table in sql?
What is scope and visibility in PL/SQL?
what is sql server agent? : Sql dba
Is null operator in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is pl/sql table? Why it is used?
Why is theta join required?
What are inner and outer joins examples of both?
What are sql constraints?
How do I find duplicates in sql?
How to raise user-defined exception with custom sqlerrm ?
How to run pl/sql statements in sql*plus?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What are the different types of joins in sql?
Advantages and disadvantages of stored procedure?
