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 create a menu in sqlplus or pl/sql?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

List out the acid properties and explain?

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---

What is sql key?

0 Answers  

---

What is the maximum rows in csv?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

---

What are the benefits of pl/sql packages?

0 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

---

What is coalesce in sql?

0 Answers  

---