Answer Posted / ajit

SQL QUERIES FOR FINDING Nth HIGHEST SALARY

SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);

How do we get field detail of a table?

1022

---

How to manage transaction isolation level?

951

---

How to create a new table in your schema?

1034

---

How to open a cursor variable?

975

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2090

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1697

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

953

---

does the query needs a hint to access a materialized view?

1817

---

What is Library Cache in Oracle?

1077

---

How to grant create session privilege to a user in oracle?

948

---

What is a data dictionary and how can it be created?

1057

---

What is a subquery in oracle?

1043

---

What is a static data dictionary in oracle?

1025

---

How to use "for" statements in oracle?

1019

---

What is the dynamic sql in oracle?

1008

---