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 an index in sql with example?

917

---

what is the difference between a having clause and a where clause? : Sql dba

1006

---

What is sql comments?

1025

---

what is a composite key ? : Sql dba

993

---

What is Difference Between Unique and Primary Key Constraints?

1057

---

how do you know if your mysql server is alive? : Sql dba

1024

---

Is big data nosql?

882

---

How do you add a column to a table?

992

---

What is the use of stored procedures?

972

---

What are the different schemas objects that can be created using pl/sql?

965

---

What is serial sql?

915

---

Is it important to partition hard disk?

964

---

How to convert comma separated string to array in pl/sql?

1104

---

explain commit and rollback in mysql : sql dba

932

---

Explain the the update statement in sql?

986

---