Answer Posted / abhishek singh

SELECT TOP 1 salary
FROM dbo.emp
WHERE (salary IN
(SELECT DISTINCT TOP n salary
FROM dbo.emp
ORDER BY salary DESC))
ORDER BY salary

What are the properties of the relational tables?

881

---

Why is replication required on the sql server?

1066

---

Can a rule be bound to any column of any data type?

965

---

Which tools are available to manage SQL Azure databases and servers?

115

---

What is the difference between a check constraint and a rule?

1257

---

What is the use of toad or sqldbx.?

1156

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1048

---

What is read uncmmited?

1065

---

What does it mean to invest in the index?

976

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1335

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

923

---

Do I need a report server to run reports in my application?

165

---

Define normalisation?

1118

---

In case you have filters in your report, when filters will be applied in cached report instance?

114

---

What is a group function explain with an example?

993

---