Answer Posted / abhishek jaiswal

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

How to take user input in pl sql?

1167

---

What is Materialized View? In What Scenario we Use Materialized View?

9522

---

What are the string functions in sql?

980

---

What is sql engine in oracle?

994

---

What is the least restrictive isolation level? : Transact sql

1070

---

How can we link a sql database to an existing android app?

1033

---

what is oracle database ? : Sql dba

1035

---

What are % type and % rowtype?

1035

---

What is a pl/sql block?

1234

---

What is normalization in sql?

1017

---

What are the three forms of normalization?

1046

---

What is union, minus and interact commands?

1300

---

What is execute immediate?

1088

---

How to use sql statements in pl/sql?

1127

---

Is mariadb a nosql database?

1056

---