How do I count duplicates in sql?



How do I count duplicates in sql?..

Answer / Tulsi Ram Yadav

To count duplicates in SQL, you can use the COUNT(*) function with a GROUP BY statement. Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is data manipulation language?

1 Answers  


what is 'force view'?

3 Answers   Cap Gemini, SPIC,


What is set transaction?

1 Answers  


What are the different tcl commands in sql?

1 Answers  


Explain the the delete statements in sql?

1 Answers  


Where is sql database stored?

1 Answers  


write the Sql query for creating database backup?

7 Answers   TCS,


What is oracle sql called?

1 Answers  


How to use sql statements in pl/sql?

1 Answers  


Will truncate release space?

1 Answers  


what is a join? : Sql dba

1 Answers  


What is pl/sql tables?

7 Answers   TCS,


Categories