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;

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

How do you change a value in sql?

0 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

Which is faster subquery or join?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

Is postgresql a server?

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

What is a variable in sql?

0 Answers  

---

What are the types of SQL Statement?

3 Answers  

---