select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

What are the two types of exceptions.

0 Answers  

---

What is schema in sql example?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

What is restrict in sql?

0 Answers  

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

What is the difference between sum and count in sql?

0 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  

---

What are pl/sql cursor exceptions?

0 Answers  

---

how to use case expression? : Sql dba

0 Answers  

---