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 kind of lan types do you know? : Sql server database administration

519

---

How to make conditional sum in ssrs?

132

---

Tell me what is sql profiler?

621

---

What is difference between count (*) and count 1?

514

---

Explain what role entity and relationship play in an ER diagram.

578

---

---

What is encryption key?

84

---

What is the difference between count () and rowcount ()?

521

---

How do triggers work?

540

---

Explain about SQLOS?

590

---

What is the sql server 2000 version number?

550

---

What is cached report?

106

---

Explain what is the difference between union and union all?

550

---

What are the different types of collation sensitivity in sql server?

585

---

Describe in brief authentication modes in sql server.

565

---

What is a trigger and types of a trigger?

569

---