Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6029 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
select distinct vehicle_no, wm_concat( date )
from vehicle_service
group by vehicle_no;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a parameter query?
What are the types of sql commands?
What is trigger explain with example?
What is lookup table in sql?
Explain mutating table error.
how is myisam table stored? : Sql dba
How to start oracle sql developer?
What is hibernate and its relation to sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the different type of joins in sql?
How to convert comma separated string to array in pl/sql?
What are the different types of constraints?
What is the purpose of design view?
When is the update_statistics command used?
What are dml commands?
