Answer Posted / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

What are the restrictions applicable while creating views? : SQL Server Architecture

1087

---

How to create an multi-statement table-valued function?

1049

---

Tell me the difference between clustered and non-clustered index?

992

---

Explain what you mean by 3 tier architecture.

1127

---

How do I make a resultset scrollable?

1014

---

What happens if null values are involved in arithmetic operations?

1050

---

Can coalesce return null?

1071

---

What is the difference between Triggers and Stored Procedure?

1157

---

What are translations and its use? : sql server analysis services, ssas

1085

---

What do you understand by physical_only option in dbcc checkdb?

1026

---

What is equi join with example?

1230

---

Tell me about joins in database system and explain each in detail.

1107

---

How to get the definition of a stored procedure back?

1022

---

Explain how to integrate the ssrs reports in application?

1063

---

How do you create a clustered index?

1130

---