select count(*) from table_name group by column1,column2... having count(

how do you count the duplicate records in a table

Question Posted / shalu

Answer Posted / shalu

select count(*) from table_name group by column1,column2...
having count(*) > 1

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What does varchar include?

952

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

What is the advantage of index in sql?

972

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1170

How do you get column names only for a table (sql server)?

1165

How do you create a unique index?

1048

What is the process of debugging?

1070

what is csv? : Sql dba

999

Is primary key clustered index?

950

What is a temporal table?

930

how to create a table index in mysql? : Sql dba

1061

Why is pl sql used?

983

how to fetch alternate records from a table? : Sql dba

1112

Name three sql operations that perform a sort.

1014

What are the basic sql commands?

1094