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 write a query to show the details of a student from students table whose

1063

---

what is self-join? : Sql dba

1244

---

What are the types pl/sql code blocks?

1197

---

What does partition by mean in sql?

1032

---

what is a cursor? : Sql dba

1066

---

Define sql delete statement.

1067

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1265

---

What is the difference between execution of triggers and stored procedures?

1159

---

explain access control lists. : Sql dba

1050

---

What is gpt format?

993

---

How do I install sql?

1046

---

What does where 1/2 mean in sql?

1145

---

What is %type in pl sql?

1013

---

which operator is used in query for pattern matching? : Sql dba

1046

---

What is the default isolation level in sql server? : Transact sql

1089

---