Answer Posted / ajay roy

The Correct answer is ---

select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)

Thanks Elumalai.k

Top Keyword returns the top(first) row not the max record

How to create new tables with "select ... Into" statements in ms sql server?

1043

---

How do I find the port number for sql server?

1015

---

when would you go for denormalization? : Sql server database administration

909

---

Which is faster statement or preparedstatement?

1001

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1002

---

When would you use sql joins?

1024

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

1031

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

7005

---

What is identity?

1080

---

Explain the difference between function and stored procedure?

995

---

How can you check the level of fragmentation on a table?

1087

---

Explain where clause?

1033

---

What is the difference between value type and reference type?

987

---

Does sql server 2000 full-text search support clustering?

910

---

What are the advantages dts has over bcp?

1047

---