Answer Posted / rahul tripathi

The Genral answer which can work on any SQL:-

select salary from emp e1 where (n-1)=(select count(*)
from emp where salary > e1.salary )

Rahul Tripathi

rahultripathi@inkanpur.com

What are various ways to enhance the ssrs report?

1034

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1098

---

Can the “if update (colname)” statement be used in a delete trigger?

1034

---

what's sql server? : Sql server database administration

1053

---

How use inner join in sql server?

1190

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

989

---

how many no of arguments can be passed in procedures and functions

5642

---

How to define and use table alias names in ms sql server?

1213

---

What is executereader?

1005

---

How do I completely remove sql server instance?

1155

---

What do you mean by SQL injection attack?

1129

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1061

---

What are information schema views?

1033

---

How to create a view using data from another view?

998

---

Explain something about security and SQL Azure?

134

---