select column,count(1) from a group by column having count(1)>1;

how do you count the duplicate records in a table

Question Posted / purushotham

Answer Posted / purushotham

select column,count(1) from a
group by column
having count(1)>1;

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Are sql connections encrypted?

566

What are the parts of a basic sql query?

518

Is sql a microsoft product?

499

what are the advantages a stored procedure? : Sql dba

553

How to pipe multiline string to isql?

580

How to execute a stored procedure?

567

How to get list of all tables from a database?

632

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2099

What is sql*loader and what is it used for?

582

What has stored procedures in sql?

605

Does truncate table reset auto increment?

528

What are tables and fields?

595

What is the use of function "module procedure" in pl/sql?

675

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1531

Is left join and outer join same?

552