Answer Posted / pavan

Hi,
try this query.In this query sal one val is duplicated
4items


select sal,count(sal) from test group by sal having count
(*)>1

Explain about link server in sql server?

1008

---

What are the new features are introduced in sql server 2012 reporting services?

143

---

Explain why variables called the most powerful component of ssis?

995

---

Name and describe few console utilities for ssrs?

276

---

What is the difference between value type and reference type?

872

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

982

---

What is the difference between a function and a trigger?

1014

---

Can you force a query to use a specific index?

889

---

What are the different types of cursor?

1042

---

How many instances per computer are there in sql server 2000?

1010

---

Does view occupy space?

887

---

Do you have any idea about the tcl commands?

913

---

Find first and last day of current month in sql server

978

---

What is the recursive stored procedure in sql server?

968

---

What do you think of this implementation? Can this be implemented better?

877

---