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
- 5911 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
Write a query to display the current date in sql?
How can we link a sql database to an existing android app?
What is the usage of when clause in trigger?
Why do we use partitions in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
What are crud methods?
How do you use a while loop in pl sql?
What are the various restrictions imposed on view in terms of dml?
Explain how exception handling is done in advance pl/sql?
Does execute immediate commit?
Can a view be mutating? If yes, then how?
What is pessimistic concurrency control? : Transact sql
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is output spooling in sql*plus?
What are the types of views in sql?
