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

Is sqlite thread safe?

993

---

What are all the ddl commands?

1118

---

What is sql*loader?

1076

---

What is sql entity?

1031

---

what is 'mysqlshow'? : Sql dba

975

---

what is sql in mysql? : Sql dba

1123

---

Inline the values in PL/SQL, what does it mean.?

1158

---

what is a foreign key ? : Sql dba

1028

---

Why we use joins in sql?

926

---

Can we call dml statement in function?

980

---

Why stored procedure is better than query?

887

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1029

---

What are the advantages of pl sql?

1074

---

Describe different types of general function used in sql?

980

---

What is schema in sql example?

1091

---