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
- 6045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of variables use in pl sql?
Explain how can you save or place your msg in a table?
How does join work in sql?
How to raise user-defined exception with custom sqlerrm ?
How many rows can sqlite handle?
Write an sql query to select all records from the table?
Define sql delete statement.
How do I restart sql?
What is record in pl sql?
What is dml with example?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How do I remove duplicates in two columns?
What is the difference between microsoft sql and mysql?
What is procedure function?
What are the dml statements?
