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 how to store and query spatial data?

1022

What are points to remember while using the fillfactor argument?

949

How to skip remaining statements in a loop block using continue statements?

979

What is the difference between the 2 operating modes of database mirroring?

1089

What is cursors? And what are the different types of cursor?

1126

What is an active database?

996

What is the largest component inside a field?

1093

Can we write trigger for view?

994

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1496

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

998

What are the advantages of having an index on the sql server?

909

Explain the difference between HTTP and HTTPS in database?

1010

how to control the amount of free space in your index pages? : Sql server database administration

1017

How to enter comments in transact-sql statements?

924

What is catalog views?

1055