Hi here is another way to solve this SELECT NAME, COUNT(NAME) FROM TABLE

how do you count the duplicate records in a table

Question Posted / sravan

10 Answers
19177 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / sravan

Hi here is another way to solve this

SELECT NAME, COUNT(NAME) FROM TABLE_NAME
WHERE NAME IN (SELECT NAME FROM TABLE_NAME
GROUP BY NAME
HAVING COUNT(NAME)>1)
GROUP BY NAME;

thanks

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is recursive stored procedure? : Sql dba

1028

What is data profiling in sql?

1139

What do you understand by pl/sql records?

1062

how can we submit a form without a submit button? : Sql dba

1037

How many scalar data types are supported in pl/sql?

1106

What is the usage of when clause in trigger?

1091

How many disk partitions should I have?

1042

Are sql connections encrypted?

1088

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2339

What is meant by <> in sql?

1029

What is a temp table?

1074

What is the difference between sum and count in sql?

1039

What are the methods of filing?

994

Why do we use joins?

1101

what are properties of a transaction? : Sql dba

1139