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 auto increment? : Sql dba

0 Answers  

---

Tell me what a package consists of.

3 Answers  

---

Can you do multiple joins in sql?

0 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

What is percent sign in sql?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

what is union? : Sql dba

0 Answers  

---

What is your daily office routine?

0 Answers   Data Vision,

---

What does joining a thread mean?

0 Answers  

---

What is an invalid partition table?

0 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---