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 is an entity-relationship diagram (erd)?

1215

---

What do you understand by mirroring?

998

---

What is the difference between a function and a stored procedure?

1074

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1140

---

What is the order in which the sql query is executed?

942

---

What is the difference between grant and with grant while giving permissions to the user?

966

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1069

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1092

---

What is Sqlpaging in SqlServer 2005 ?

1072

---

Explain primary key?

972

---

How to enter date and time literals in ms sql server?

1017

---

What is primary key, unique key, and foreign key?

976

---

how to determine the service pack currently installed on sql server? : Sql server database administration

976

---

what is difference between view and Dip.

2412

---

Does full backup break log chain?

970

---