What does select top 1 do in sql?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What is record in pl sql?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

what is the difference between granting and creating a view?

2 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

How would you convert date into julian date format?

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---