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)

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1188

---

What is a trigger and its types?

1039

---

Can I disable or restrict ssrs export formats (rendering formats)?

155

---

What is transaction server distributed transaction?

1126

---

Do you know what are various aggregate functions that are available?

1215

---

what are isolation levels? : Sql server database administration

1058

---

Explain Normalization and DE normalization

1160

---

Why Master database is required?

1185

---

In which sql server version report builder introduced?

150

---

How do I connect to sql server database?

1065

---

Explain primary key, foreign key and unique key?

1024

---

What is index in an assignment?

997

---

What is standby servers? Explain types of standby servers.

1052

---

How to write a query with a full outer join in ms sql server?

1156

---

What is sleeping status in sql server?

1075

---