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 index in Oracle?

1076

---

What is analyze command used for?

1080

---

How to assign data of the deleted row to variables?

1077

---

What is the data pump export utility?

1086

---

what are bitmap indexes? How does they work?

2259

---

What privilege is needed for a user to create indexes in oracle?

1028

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2210

---

What is an oracle user role?

986

---

How to convert a string to a date in oracle database?

1056

---

How to rename an index in oracle?

1118

---

What is oracle open database communication (odbc)?

1030

---

What is user managed backup in Oracle?

1148

---

How to loop through a cursor variable?

1091

---

How to delete all rows a table in oracle?

1071

---

What is the difference between view and materialized view in Oracle?

1159

---