Answer Posted / mallinathabj

The Following queries to retrieve the second highest salary

SQL> select max(sal) from emp where sal<(select
max(distinct(sal)) from emp);

SQL> select min(sal) from(select distinct( sal) from emp order
by sal desc) where rownum<=2;

SQL> SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT
MAX(SAL) FROM EMP);

What is scope of pl sql developer in future?

1070

---

What are different types of queries in sql?

1174

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1184

---

How do you bind variables in pl sql?

1160

---

Explain locks? : Transact sql

1054

---

How does sql profiler work?

1065

---

How many sql are there?

1052

---

Explain autonomous transaction.

1220

---

What is the difference among union, minus and intersect?

1049

---

What is varray in pl sql?

1120

---

Define join and name different types of joins?

1054

---

What is the difference between the conventional and direct path loads? : aql loader

1473

---

How many indexes can be created on a table in sql?

1114

---

What is pl sql commands?

1097

---

What does fetching a cursor do?

1133

---