Answer Posted / debasish

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

what is a join and explain different types of joins? : Sql server database administration

927

---

Can another user execute your local temporary stored procedures?

954

---

System requirements for sql server 2005 express edition?

965

---

How to run sql server 2005 books online on your local system?

935

---

Can you roll back the ddl statement in a trigger?

924

---

What happens if you delete a table that is used by a view?

951

---

How to modify the underlying query of an existing view?

948

---

How do I edit a procedure in sql server?

916

---

What is normalization and what are the advantages of it?

942

---

How does stuff differ from the replace function?

974

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

980

---

what is raid? : Sql server database administration

991

---

Explain about system database?

1019

---

How to generate random numbers with the rand() function in ms sql server?

1079

---

What is merge?

960

---