Answer Posted / v.karthikeyan

select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

How to create an oracle testing table?

584

---

What is the difference between count (*), count (expression), count (distinct expression)?

547

---

Explain cascading triggers.

564

---

if you ctreate table identity

1836

---

How to create a table index?

552

---

---

What is columnar storage what is the advantage?

536

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1941

---

How remove data files before opening a database?

550

---

How to start an oracle instance?

564

---

What is a proxy class?

548

---

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

526

---

Explain the difference between sap and oracle?

566

---

What are the database administrators utilities available?

571

---

What is meant by a deadlock situation?

569

---

What are the major difference between truncate and delete?

507

---