Answer / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Answer / neo devan

select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));

Why do we use bulk collect in oracle?

0 Answers  

---

Describe varray?

0 Answers  

---

Does oracle partitioning improve performance?

0 Answers  

---

What are the different types of database objects?

0 Answers  

---

Differentiate between pre-select and pre-query?

0 Answers  

---

What is oracle join syntax?

0 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

what is the use of ondelete cascade?

3 Answers  

---

Explain about achiever in sql?

0 Answers  

---

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

---

What are the types of trigger in oracle?

0 Answers  

---

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  

---