Answer Posted / venuprasadh

SELECT MIN(SALARY) AS Salary FROM user WHERE SALARY IN
(SELECT DISTINCT TOP 3 SALARY FROM user ORDER BY SALARY DESC);

What is the difference between a function and a trigger?

1012

---

If user is owning any SQL Objects, can we drop that user

2004

---

What is sql server used for?

987

---

How to list all field names in the result set using mssql_field_name()?

867

---

Why we use trigger in sql server with example?

916

---

How to send email from database?

947

---

What is the difference between clustered and a non-clustered index?

972

---

What is database mirroring?

1037

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1964

---

In what sequence sql statement is processed?

952

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

985

---

Tell me what is the order in which the sql query is executed?

895

---

can an automatic recovery be initiated by a user? : Sql server administration

893

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

881

---

how to create “alternate row colour”?

142

---