ฝัง
- เผยแพร่เมื่อ 5 ก.พ. 2025
- Hey its very simple to Find Duplicate Rows or record In a Table? Just watch the video now. I hope this video helps you.
Please Like , share and subscribe.
Join our Telegram Channel - t.me/joingroup...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Find Nth Highest Salary in SQL | 5 Different Ways
• Find Nth Highest Salar...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Find the number of Employees working in each department | SQL
• Find the number of Emp...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )
• Aggregate Functions In...
⭐Difference Between DELETE, DROP and TRUNCATE
• Difference Between DEL...
⭐SQL vs NoSQL | MySQL vs MongoDB
• Difference between SQL...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Normalization in DBMS-
• Normalization and its ...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐Create MySQL Database and Table -
• How to Create Database...
#mysql #oracle #dbms #query #top #sqlserver #database #PlacementPreparation
![3 Ways To Find Duplicate Rows In Sql | SQL Query To Find Duplicate Records [2021]](http://i.ytimg.com/vi/FCTFkWh99hI/mqdefault.jpg)
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
correct
Or Use this : select * , count(*) over (partition by Email_id) as duplicate from employees_1
Hai, madam ur classes r super.
Ur voice is also super
Thanks a lot.
Most important qns👍👍
Great explanation on dupes identification.
Thank you so much😊
Simple and nice explanation,In next vlog could you please demonstrate about dropping out duplicate records
Sure
thanqq ma'am please make some video on interview question
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.
Hi saloni madam any query to find duplicate data row without knowing the database means we know only data table name and column name
Nice yaar
Thank you
Osm😎
Thank you so much
Very nice explanation
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
Nice video , very good Didi
Thanks for watching
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
Nice explanation
Nice explain 🤗
Thank you
Excellent Madam
Please do the video on corelated sub query and normalization 🙏
We will try our best.. Thank you so much for watching
thanks for your help🙂
Thanks a lot 😊
So happy to know that you like it.. Thank you for watching
@@CodeEra2020 your welcome ....
Nice mam ❤️
Thank you so much for watching
My question is , how do we display the total in frontend because you are using the query inside the database
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.
@@CodeEra2020 am using php
$sql1 = "select sigles, COUNT(*) AS totalnumber from tbl_student group by sigles ";
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
your syntax is wrong concept is right
best
nice didi
Thank you so much
Great 👍🏻
Comp😊