Answer Posted / kss

Hi every one,

i know that we can get that thr above quer..

one can try using analytic function giving ranks to the
salary column

select sal,dense_rank() over(order by sal desc) rank from
emp

What is materialized view in Oracle?

1074

---

What are the different types of partitions in oracle?

979

---

Explain do view contain data?

1013

---

How to drop an existing view in oracle?

946

---

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

1054

---

What are the extensions used by oracle reports?

1038

---

Explain an exception?

1000

---

Calculate difference between 2 date / times in oracle sql?

1041

---

Differentiate between post-database commit and post-form commit?

1048

---

How to turn on or off recycle bin for the session?

1110

---

What is blob data type in oracle?

1123

---

Oracle

2378

---

What is Virtual Private Database in Oracle?

1091

---

How to shutdown your 10g xe server from command line?

1087

---

How to create a new tablespace in oracle?

987

---