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 assignment operator in pl sql?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

What are keys in sql?

0 Answers  

---

Explain Connect by Prior?

2 Answers  

---

Explain what is rdbms?

0 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

What is pl sql in dbms?

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

Can a select statement fire a trigger?

0 Answers  

---

How does an execution block start and end in pl sql?

0 Answers  

---

what is the difference between $message and $$message? : Sql dba

0 Answers  

---