Answer Posted / yogesh

select e2.salary
from emp e1
join emp e2
on e1.salary >= e2.salary
group by e2.salary
having count(e2.salary) = n

 Explain what is sql override for a source taLle in a mapping?

947

---

how would you store your query in an SSRS report or a Database server?

152

---

What have included columns when we talk about sql server indexing?

992

---

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

841

---

How many tables can be joined in SQL Server?

1006

---

define and explain the differences between clustered and non-clustered indexes.

1120

---

What language is sql server written in?

989

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1168

---

Is t sql the same as sql server?

921

---

How to check if stored procedure is running in sql server?

962

---

what is the difference between count(*) and count(1) ?

1028

---

What is sql server english query?

1041

---

What are the differences between left join and inner join in sql server?

1042

---

What is forward - only cursors / read only cursor?

1023

---

How each E-R model constructs can be mapped to the relational model?

922

---