How would you pass hints to the sql processor?

0 Answers  

---

Is join and inner join the same?

0 Answers  

---

What are sql constraints?

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

How to update salary of employees department wise?

6 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

What are the indexing methods?

0 Answers  

---

Can u create a primary key with out unique index.

8 Answers  

---

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  

---

How many aggregate functions are available there in sql?

0 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---