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
- 4799 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 can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is sql and also describe types of sql statements?
What is trigger in sql?
What is difference between sql and mysql?
Why are aggregate functions called so?
What is the difference between a subquery and a join?
Can we use pl sql in mysql?
What trigger means?
Can there be more than one function with a similar name in a pl/sql block?
Is json a nosql?
Explain two easy sql optimizations.
Is join an inner join?
what is a record in a database ? : Sql dba
What is pl/sql language case sensitive?
Is merge a dml statement?
