Answer Posted / your name

Forget everything...Here it goes..in a simple way...

Select salary from tbl_name a where
n = (Select count(distinct(count(*))) from tbl_name b
where b.salary>=a.salary)

Substitute you value for n. thats all.

What is the maximum size of a dimension? : sql server analysis services, ssas

1010

---

What encryption security is available in sql azure?

99

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

1026

---

What happens when the SQL Azure database reaches Max Size?

109

---

Mention the different types of replication in sql server.

976

---

What is an inner join?

932

---

Can We Use Data-grids For Our Report In Ssrs?

182

---

What is the use of keyword with encryption. Create a store procedure with encryption?

915

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1344

---

Write a query for primary key constraint with identity key word?

989

---

Define magic tables in sql server?

1011

---

Explain syntax for viewing, dropping and disabling triggers?

912

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

954

---

What are the default system databases in sql server 2000?

981

---

What is normalization and denormalization in sql server?

963

---