Answer Posted / ranjeet kumar shrivastava

select * from tbl_htl_cntry e where 2>=(select
count(distinct salary) from tbl_htl_cntry where
e.salary<=salary)

it is aslo working syntax.
ranjeetvasu@rediffmail.com

Is sql server implemented as a service or an application? : Sql server database administration

994

---

What do you know about system database? : SQL Server Architecture

1034

---

What is the maximum rows in sql server table?

961

---

What is a non equi join?

1021

---

Does sql server 2000 clustering support load balancing?

1024

---

What's the information that can be stored inside a bit column?

1068

---

What is instead of dml trigger?

1054

---

List the data types available in mssql?

1101

---

What stored by the model?

1139

---

How can I create a report based on a query? : sql server management studio

1061

---

What are entities and relationships?

1021

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1035

---

What is normalization? Describe its different types.

1151

---

Explain try...catch with sql server?

1071

---

What is master database? : SQL Server Architecture

1080

---