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

Can I create users through internet explorer in oracle 10g?

1020

---

What is the relationship among database, tablespace and data file?

929

---

What is an oracle database table?

962

---

What is user managed backup in Oracle?

1078

---

What are the advantages of oracle?

963

---

What are the attributes of the cursor?

936

---

How to rename an existing table?

1052

---

How to fetch the row which has the max value for a column?

950

---

how to join query for one source type is oracle another source type is sql server ?

2379

---

What is meant by recursive hints in oracle?

1029

---

Explain database link?

1062

---

How to define an external table with a text file?

1021

---

What is sequence?

1012

---

What is bulk collect in oracle?

958

---

How to apply filtering criteria at group level in oracle?

987

---