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 does partition by mean in sql?

0 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

What are the advantages of stored procedure?

0 Answers  

---

Explain foreign key in sql?

0 Answers  

---

What is the maximum size of sqlite database?

0 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---

What can I use instead of union in sql?

0 Answers  

---

Define the select into statement.

0 Answers  

---

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---

Differentiate between syntax and runtime errors.

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---