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)
/

Can we create index on primary key?

916

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

993

---

What are tables and fields?

976

---

What is the best partition size for windows 10?

947

---

What are the parts of a sql statement?

1030

---

How bulk collect improves performance?

949

---

explain primary keys and auto increment fields in mysql : sql dba

902

---

What do you mean by “trigger” in sql?

1019

---

What is cross join example?

942

---

What are the most important characteristics of pl/sql?

1080

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2414

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2111

---

What is a data definition language?

1030

---

how would you enter characters as hex numbers? : Sql dba

939

---

What is cte?

924

---