Answer Posted / mahesh

We can use an OLAP function
select * from
(select ename,sal,dense_rank() over(order by sal desc)
rankings from emp ) a
where a.rankings = 2;

What is the quickest way to export a table to a flat file?

968

---

What is index-organized table in Oracle?

1069

---

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

1011

---

What is oracle database 10g express edition?

1121

---

Explain the use of grant option in imp command.

1030

---

How to Truncate Table in Oracle

1159

---

How to build data dictionary view an new database?

1012

---

How to calculate date and time differences in oracle?

1044

---

How can you use check constraints for self referential integrity?

971

---

What are the differences between lov and list item?

1069

---

How to use attributes of the implicit cursor in oracle?

1011

---

Write a syntax for update query in oracle?

1036

---

Give the advantages and disadvantages of clusters.

1052

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

---

How does the on-delete-cascade statement work?

1114

---