Answer / nashiinformaticssolutions

Using a subquery:
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
Using ROW_NUMBER():
SELECT salary
FROM (
SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS row_num
FROM employees
) ranked
WHERE row_num = 2;

Answer / glibwaresoftsolutions

Using a subquery:
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
Using ROW_NUMBER():
SELECT salary
FROM (
SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS row_num
FROM employees
) ranked
WHERE row_num = 2;

Answer / hr@tgksolutions.com

Using a subquery:
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
Using ROW_NUMBER():
SELECT salary
FROM (
SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS row_num
FROM employees
) ranked
WHERE row_num = 2;

What is mutating error in pl sql?

0 Answers  

---

What is query execution plan in sql?

0 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

What is a unique key?

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---

How do I view a view in sql?

0 Answers  

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---

Is sql between inclusive?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

what is an index? : Sql dba

0 Answers  

---