Answer Posted / bharath

select e1.* from emp e1
where &n=
(select count(distinct(*))
from emp e2
where e2.sal>e1.sal);

How do I uninstall oracle 11g?

1178

---

Can select statements be used on views in oracle?

1084

---

What do you mean by merge in oracle and how can you merge two tables?

1007

---

Explain the characteristics of oracle dba?

1176

---

What is meant by a deadlock situation?

1156

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1165

---

Is there any function in oracle similar like group_concat of mysql?

1109

---

what are the default admin accounts in Oracle 10g ?

1024

---

How many types of tables are there in oracle?

1112

---

What is a parameter file in oracle?

1191

---

How can I create database in oracle?

1069

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2080

---

What is oracle data type?

1011

---

What are the execution control statements?

1110

---

Explain the use of grant option in exp command.

1112

---