Answer Posted / balindra sahani

select max(salary) from table_name where max(salary)not
in(select top(n) from table_name order by salary asc)

where n=nth number salary

What is multi-statement table-value user-defined function?

999

---

What are magic tables in sql server?

1138

---

What is recompile sql server?

1043

---

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

1209

---

Where views are stored in sql server?

991

---

Does sql server 2000 full-text search support clustering?

870

---

What gets stored inside msdb database?

1252

---

What are a database and a data warehouse?

1023

---

Do you know the isolation level that sql server support?

965

---

How to check status of stored procedure in sql server?

988

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5925

---

What is a cursor, index in sql?

1075

---

How to create dbo table in sql server?

957

---

How to download and install microsoft .net framework version 2.0?

1139

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2588

---