Answer Posted / ankur bakliwal

I think this should work -


select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc

What are the steps you will take to improve the performance of a poor performing query?

948

---

Tell me the phases a transaction has to undergo?

931

---

How to turn on the mssql api module in php?

1033

---

What is normalization and denormalization in sql server?

968

---

Give a example to search fr a string in all stored procedure in sql server.

934

---

What is ssl in sql server?

1034

---

Can two tables share the same primary key?

876

---

List the types of recovery model available in sql server?

892

---

How to add more data to the testing table in ms sql server?

1029

---

Mention the uses of stored procedures.

938

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

923

---

How to apply filtering criteria at group level with the having clause in ms sql server?

966

---

What are the common performance issues in sql server?

886

---

How and why use sql server?

978

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1006

---