Answer Posted / welcomeashwin

--2 ND HIGHEST SALARY
SELECT MAX(SALARY) FROM HR.EMPLOYEES
WHERE SALARY < (SELECT MAX(DISTINCT(SALARY)) FROM
HR.EMPLOYEES);

--N TH HIGHEST SALARY
SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

how to return query output in html format? : Sql dba

1073

---

What are the key differences between SQL and PL SQL?

1211

---

Explain exception handling in pl/sql?

1033

---

What is trigger explain it?

1011

---

Explain what is table in a database?

1055

---

What is data modelling in sql?

1014

---

Can a view be mutating? If yes, then how?

1025

---

How sql query is executed?

1127

---

How to run sql commands in sql*plus?

1175

---

What does stand for in sql?

964

---

What is parameter substitution in sql?

1024

---

what are aggregate and scalar functions? : Sql dba

1054

---

What are the different types of triggers?

1130

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2109

---

How do I count rows in sql?

998

---