Answer Posted / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

979

---

What does normalization do to data?

1015

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

921

---

How to retrieve field values using mssql_result()?

1234

---

What are joins in sql and what are the different types of joins?

985

---

Mention the uses of stored procedures.

938

---

What are the differences between stored procedure and view in sql server?

1187

---

Tell me something about security and sql azure?

114

---

Does index speed up select statements?

992

---

What is table level trigger?

972

---

Describe how to use linked server?

959

---

What is a document index?

993

---

What is the difference between TRUNCATE and DROP?

1085

---

How to return the top 5 rows from a select query in ms sql server?

1095

---

What is the difference between sdf and mdf?

1263

---