Answer Posted / parmesh m

select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1061

---

What are the drawbacks of reporting in ssrs?

159

---

Describe the left outer join & right outer join. : sql server database administration

1038

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1109

---

How to find Duplicate Records In table?

1076

---

Explain the working of sql privileges?

1146

---

How to use copy and concatenate commands in SQL?

1203

---

What are different types of roles provided by ssrs?

156

---

What is pivot and unpivot?

1066

---

What are the diifferences between the ms sql server vs mysql?

1240

---

Define constraints and give an example of their use?

1099

---

Do you know what is a with(nolock)?

1104

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1055

---

What is difference between table aliases and column aliases? Do they affect performance?

1021

---