Answer Posted / kavitha.r

Sorry. This one is correct


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

How to provide values to user defined function parameters?

551

---

How to create a scrollable cursor with the scroll option?

492

---

What is merge statement?

619

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

521

---

What are the advantages dts has over bcp?

522

---

---

What happens if ntwdblib.dll is missing on your machine?

628

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1212

---

Do you know what are the steps to process a single select statement?

526

---

what is nonclustered index

534

---

What is the use of set nocount on/off statement?

620

---

What is the difference between for xml raw and for xml auto?

557

---

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

573

---

What is table join?

593

---

Does index speed up select statements?

579

---

Explain tables in SQL Azure?

94

---