Answer Posted / chan

SELECT ID, SALARY FROM
(
SELECT ID, SALARY, ROW_NUMBER() OVER (ORDER BY SALARY) AS RN
FROM EMPLOYEE
)
WHERE RN = 1

(YOU CAN CHANGE VALUE OF RN = ANY NUMBER AND YOU WILL GET
THAT VALUE)

What happens when converting big values to integers?

959

---

Can I save my report as html, excel or word? : sql server management studio

908

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1014

---

Write a sql query to display the current date?

1030

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

971

---

How is SQL Azure different than SQL server?

223

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

902

---

What do you mean by tablesample?

1035

---

What are the different types of Indexes available in SQL Server?

951

---

What is function of ROLLUP ?

1041

---

What are functions in the sql server?

1128

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

---

What is policy based management (pbm)? : sql server database administration

931

---

How to start and end transact-sql statements?

971

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

996

---