Answer Posted / venkata

hi, earlier query return sal in asending order and when
duplicate salries are there the earlier highest salary
position returns no rows. I hope this is better query.


select * from (select * from emp order by sal desc)
group by
rownum,empno,ename,job,mgr,hiredate,sal,comm,deptno having
rownum=&n

What is merge statement used for?

1005

---

Is rowid unique in oracle?

980

---

How can we force the database to use the user specified rollback segment?

1120

---

How to lock and unlock a user account in oracle?

1082

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1089

---

What is ordinary table in oracle?

1132

---

What is the difference between pre-select and pre-query?

1190

---

How to open and close an explicit cursor in oracle?

1031

---

How index is implemented in oracle database?

981

---

What is snapshot is too old? Give and example for better understand.

1591

---

State and explain about oracle instance?

979

---

What is bulk load in oracle?

1051

---

What is using clause and give example?

1017

---

How to pass parameters to procedures?

1016

---

6. Display the client name and order date for all orders using the traditional method.

2291

---