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

How to retrieve error messages using mssql_get_last_message()?

1054

---

How to identify current user in ssrs report?

403

---

How to defragment indexes with alter index ... Reorganize?

1088

---

Describe and explain about SQL native client?

1109

---

How do I start sql server agent automatically?

973

---

Write down the syntax and an example for create, rename and delete index?

986

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

963

---

How can we remove orphan records from a table?

986

---

What are the key configuration files for sql server reporting services ?

167

---

Do you know the policy based administration feature of sql server 2008?

959

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

985

---

Is it possible in sql table to have more than one foreign key?

1034

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1073

---

How many joins in sql server?

958

---

What is resource db in sql server?

1026

---