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

How to count the number of duplicate items in a table?

Question Posted / pavan

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

Please Help Members By Posting Answers For Below Questions

Do you know nested transaction?

1002

Are all views updatable ?

1201

What do you mean by subquery?

1149

What is the difference between grant and with grant while giving permissions to the user?

1025

What are Spatial data types in SQL Server 2008

1072

What is transact-sql ddl trigger?

1148

How to rename an existing column with sql server management studio?

1053

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1331

How to use subqueries with the exists operators in ms sql server?

1179

How to define the name and server for a new dsn?

1196

What is the stuff?

1059

What is open database communication (odbc)?

1115

What is server-level principal?

122

What are rows and columns?

1065

What are character string data types in ms sql server?

1349