Answer Posted / ashish damohiya

Answer :
Select max(salary) from Emp_Table where max(salary) not in
(Select max(Salary) from Emp_Table)
this sufficient answer.

but there change the format of question that
How to find the second highest salary of each employee form
emp table ?

Answer :

with cte as (
select rank() over(order by emp_name) rank1 , ROW_NUMBER()
OVER(partition by emp_name ORDER BY basic desc) row,
emp_name, basic from emp_master)
select * from cte where row =2 or rank1 in ( select rank1
from cte group by rank1 having count(rank1)=1)

there i am used the MS SQL Server 2005.

what are the types of join and explain each? : Sql dba

991

---

What do you mean by dbms? What are its different types?

952

---

Is sql between inclusive?

1064

---

Explain lock escalation? : Transact sql

1144

---

What is use of package in pl sql?

953

---

What is sap sql?

928

---

Differentiate between sga and pga.

1090

---

Is left join and outer join same?

1006

---

How show all rows in sql?

975

---

What are sql injection vulnerabilities?

911

---

What is nosql db?

926

---

What does fetching a cursor do?

1022

---

How can you load microsoft excel data into oracle? : aql loader

1130

---

What will you get by the cursor attribute sql%rowcount?

974

---

What is union and union all keyword in sql and what are their differences?

1047

---