How to count the number of duplicate items in a table?
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
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How to retrieve error messages using mssql_get_last_message()?
How to identify current user in ssrs report?
How to defragment indexes with alter index ... Reorganize?
Describe and explain about SQL native client?
How do I start sql server agent automatically?
Write down the syntax and an example for create, rename and delete index?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How can we remove orphan records from a table?
What are the key configuration files for sql server reporting services ?
Do you know the policy based administration feature of sql server 2008?
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
Is it possible in sql table to have more than one foreign key?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
How many joins in sql server?
What is resource db in sql server?