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 do I use google cloud in sql?

1144

---

What are the two types of cursors in pl sql?

1121

---

What is a parameter query?

1141

---

What is foreign key and example?

982

---

What are different types of sql?

1263

---

Is sql the best database?

1023

---

What is trigger and types?

1069

---

What is sequence in sql?

1075

---

What is indexing oracle sql?

1143

---

Is sql pronounced sequel or sql?

1338

---

What is Materialized View? In What Scenario we Use Materialized View?

9616

---

Explain what is sql*plus?

1196

---

What is rename in sql?

1017

---

what are date and time intervals? : Sql dba

1103

---

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

2163

---