select coloumn_name ,count(*) from table_name group by coloumn

how do you count the duplicate records in a table

Question Posted / priya

Answer Posted / priya

select coloumn_name ,count(*) from table_name
group by coloumn_name
having count(*) > 1;

Is This Answer Correct ?

35 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to display the records between two range in Oracle SQL Plus?

1098

How to select random rows from a table?

1019

What is the difference between row level and statement level trigger?

958

Is pl sql still used?

925

Is oracel sql developer written in java?

1058

How do I run a sql query in pgadmin 4?

904

What is auto increment?

935

Is full outer join same as cross join?

913

What is the use of %rowtype?

976

What is view? Can we update view

1352

What are the uses of sysdate and user keywords?

1050

How long will it take to learn pl sql?

889

What is the process of copying data from table a to table b?

1035

is mysql query is case sensitive? : Sql dba

1030

What is the best sql course?

930