SQL: How to find duplicate in a table Testing: Diff between regression and sanity What is exhaustive testing What is load, peak and stress testing API: Difference between post and put method Diff API status codes Agile Methodology: what is velocity and how to calculate Diff ceremonies in scrum What is zero sprint etc.

Question

Accepted Answer

SQL query to find duplicates in a table

Use GROUP BY and HAVING clause
SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Can be used to find duplicates in a single column or multiple columns

Popular interview questions of Senior Tester

Top HR questions asked in Dunnhumby Senior Tester