Answer / sudarshanbehera07@gmail.com

Ans: sum_1 max_1 count_1
2014 2011 3

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  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

What is recursive stored procedure?

0 Answers  

---

How long will it take to learn pl sql?

0 Answers  

---

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

Is pl sql a programming language?

0 Answers  

---

Explain the rollback statement?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What is $$ in sql?

0 Answers  

---

Explain alias in sql?

0 Answers  

---