How To Find Duplicate Rows In a Table | SQL | Interview Preparation

[@sravaniB-u9z]

it didn't for my 'select *, count(*) from employees_1 group by id'
when we take select *, it was expecting all cols should be present in group by as well

[@saurabhkhadse8022]

correct

[@shivamrajguru6822]

Or Use this : select * , count(*) over (partition by Email_id) as duplicate from employees_1

[@ShravanKumar-me6iy]

Hai, madam ur classes r super.
Ur voice is also super

[@CodeEra2020]

Thanks a lot.

[@shaktijyoti4553]

Simple and nice explanation,In next vlog could you please demonstrate about dropping out duplicate records

[@CodeEra2020]

Sure

[@etlqalabs5048]

Great explanation on dupes identification.

[@CodeEra2020]

Thank you so much😊

[@bhadru3620]

Most important qns👍👍

[@rainbowclouds66]

Can you show me how to retrieve ONLY the duplicates, and show them all, even if identical? The result of the query should be a total of 4 lines - two for Rohit and two for Sanket. Thanks.

[@rvd371]

Hi saloni madam any query to find duplicate data row without knowing the database means we know only data table name and column name

[@rishabhrishu1602]

thanqq ma'am please make some video on interview question

[@Shortzzz_123]

If source count and distinct counts are not matching and I'm target count and distinct counts are matching how will we find what's missing btwn source and target

[@bhadru3620]

Please do the video on corelated sub query and normalization 🙏

[@CodeEra2020]

We will try our best.. Thank you so much for watching

[@joelesthak2551]

Write a query to report the IDs of all the products that were ordered there or more times in two consecutive years.
Can you please send me the answer

[@radhasakhi4546]

Nice video , very good Didi

[@CodeEra2020]

Thanks for watching

[@katojkalemba]

My question is , how do we display the total in frontend because you are using the query inside the database

[@CodeEra2020]

For these you have to use any backend technology like java. so that you can connect your Frontend with database. Then you can show your result on fronted.

[@katojkalemba]

@@CodeEra2020 am using php
$sql1 = "select sigles, COUNT(*) AS totalnumber from tbl_student group by sigles ";

[@katojkalemba]

that is my code so I have also used totalnumber as a tempolary email, but am wondering whether I can user echo count('totalnumber') to display in frontend

[@palakmahajan9999]

Nice explain 🤗

[@CodeEra2020]

Thank you

[@mohdfaizal9485]

Very nice explanation

[@nagamanickam6604]

Nice explanation

[@arjunchaurasiya6709]

Thanks a lot 😊

[@CodeEra2020]

So happy to know that you like it.. Thank you for watching

[@arjunchaurasiya6709]

@@CodeEra2020 your welcome ....

[@ozgurdoganoglu9209]

thanks for your help🙂

[@ChandraSekhar-jx5hv]

Excellent Madam

[@jaymahajan3871]

Nice yaar

[@CodeEra2020]

Thank you

[@mrinalbera6080]

Nice mam ❤️

[@CodeEra2020]

Thank you so much for watching

[@sourabhgaming1431]

Osm😎

[@CodeEra2020]

Thank you so much

[@madhukantaneema4736]

nice didi

[@CodeEra2020]

Thank you so much

[@mohdfaizal9485]

Great 👍🏻

[@marvhan888]

best

[@akshaypawar7449]

Comp😊