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)

Can one drop a column from a table?

753

---

What does select 1 mean?

730

---

How to override dml statements with triggers?

752

---

What is the server name in sql server?

718

---

What is join and name different type of joins?

776

---

What is the maximum size of column in sql server?

668

---

What is dirty read?

811

---

How to drop existing views from a database in ms sql server?

741

---

What is dimension table? : sql server analysis services, ssas

748

---

what are the new features introduced in sql server 2000? : Sql server database administration

703

---

Tell me about builtinadministrator?

724

---

Which are the third-party tools used in sql server and why would you use them?

662

---

What is difference between Datepart() and Datename() in SqlServer?

908

---

Define tool Manage Statistics in SQL Server 2000 query ?

740

---

Why use cursor in sql server?

736

---