Answer Posted / ganesh prasad

all are not working properly incase repeat salary
this one is correct

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

How to replace the Query Result 'Null Value' with a text ?

1048

---

How to assign null values to variables or columns?

982

---

What are policy management terms?

988

---

How to get the definition of a trigger back?

1003

---

Define inner join? Explain with an example?

1004

---

What are the advantages of paper records?

971

---

Does sql server use t sql?

1029

---

How do I debug a stored procedure in sql server?

1115

---

Explain what are the authentication modes in sql server?

1023

---

Write a query to find 5th highest amount paid from the customer table.

935

---

What is instead of dml trigger?

1009

---

what is a deadlock? : Sql server database administration

1074

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2003

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

958

---

Explain indexed views?

988

---