Answer Posted / ganesh prasad

all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722

select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)

what kind of lan types do you know? : Sql server database administration

926

---

What is CTE in SQL

876

---

What is indexed view? How to create it?

932

---

How do I save a stored procedure in sql server?

931

---

How can you append an identity column to a temporary table?

877

---

What is update_statistics command?

1021

---

Explain the commands in sql server?

969

---

what are isolation levels? : Sql server database administration

913

---

What are the difference between clustered and a non-clustered index?

980

---

Can we use where clause with group by?

858

---

what are defaults? : Sql server database administration

1008

---

What are scalar functions?

949

---

What do you know about system database? : SQL Server Architecture

932

---

What are the common performance issues in sql server?

871

---

What is bookmark link in ssrs?

234

---