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 user defined datatypes and when you should go for them? : Sql server database administration

1028

---

What is the command used to recompile the stored procedure at run time?

1085

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

2000

---

How to find index size for each index on table?

1007

---

What is importing utility?

997

---

What types of Joins are possible with Sql Server?

1130

---

Can an automatic recovery be initiated by a user?

1021

---

How would you choose between a clustered and a non-clustered index?

983

---

Can we use pragma autonomous_transaction in trigger?

972

---

What is abstracting periodical?

953

---

How to bind a view to the schema of the underlying tables?

1004

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1013

---

What security features are available for stored procedure?

1042

---

what is a correlated sub-query? : Sql server database administration

949

---

How to create a local temporary stored procedure?

1002

---