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

Differentiate between syntax and runtime errors.

642

What are different types of sql commands?

516

What is snowflake sql?

582

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

667

What is auto increment feature in sql?

626

How do I debug a stored procedure?

634

Why is a trigger used?

531

How do I run sql profiler?

588

Explain how can you save or place your msg in a table?

597

Why do we create stored procedures & functions in pl/sql and how are they different?

507

What are the three pl sql block types?

573

What is rownum and rowid?

572

What are the operators used in select statements?

578

Explain what is a subquery ?

659

How to prepare for oracle pl sql certification?

577