Answer Posted / ron

if you need to select by department then analytic function
is more readable:
1. use row_number() partition by dept order by sal desc as rn,
2. in where clause choose rn <4;

you can use rank() instead; if 2 or more employees have same
salary.

What are data pump export and import modes?

1048

---

types of indexes and the rationale behind choosing a particular index for a situation.

2498

---

How do I start tns listener?

1026

---

What are the advantages of oracle 12c?

1163

---

What is meant by joins?

1043

---

How to convert csv to table in oracle?

974

---

What are the different types of database objects?

1042

---

What is the data pump import utility?

1017

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2281

---

can u plz provide me oca sql dumps please i need them

1931

---

How different is ms access and oracle?

1020

---

Can a formula column referred to columns in higher group ?

2490

---

How to experiment a data lock in oracle?

1040

---

What is a database table in oracle?

1001

---

What is the parameter mode that can be passed to a procedure?

1021

---