Тёмный

3 Ways To Find Duplicate Rows In Sql | SQL Query To Find Duplicate Records [2021] 

Learning with Rohan
Подписаться 8 тыс.
Просмотров 44 тыс.
50% 1

This video is about sql query to find duplicate records valuable information but also try to cover the following subject:
-3 ways to find duplicate rows in sql
-sql query to find duplicate records in a column
-query to find duplicate records in a table sql server
#SQL #Queries #interview #Query #complex
Something I noticed when I was researching information on sql query to find duplicate records was the lack of relevant info.
Sql query to find duplicate records however is an subject that I understand something about. This video for that reason should be relevant and of interest to you.
_________________________
Follow our videos concerning sql query to find duplicate records and also other comparable topics on
Facebook:
Twitter:
++++++++++++++++++++++
Have I responded to all of your questions about sql query to find duplicate records?
People who looked for 3 ways to find duplicate rows in sql likewise searched for sql query to find duplicate records in a column.
Useful search key word
sql query to find duplicate records in a table without primary key,sql query to find duplicate records based on two fields,sql query to find duplicate records in a table and delete,sql query to find duplicate records in two tables,oracle query to find duplicate records in multiple column,sql query to find duplicate records in a multiple column,query to find duplicate records in a table sql server
sql interview questions,sql interview queries,sql tricky queries,sql interview questions and answers,sql interview query questions and answers,sql interview queries for experienced,complex sql queries interview questions,important sql queries for interview,basic sql queries,beginner sql queries,sql queries tutorial,sql queries examples,sql queries interview questions and answers,sql queries interview questions,sql advanced queries,sql complex queries

Опубликовано:

 

4 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@tnmyk_
@tnmyk_ Год назад
Great explanation! Thanks for making this video! The timestamps are useful as well!
@enriquejpsa
@enriquejpsa Год назад
This helped me find a unique constraint at my employer's Production environment. Thanks for posting!
@LearningwithRohan
@LearningwithRohan Год назад
You are welcome
@paxi5765
@paxi5765 2 года назад
hello,when i'm using many left join i get duplicate rows. and how to tuning it without to using row_number to delete that
@Alltec2233
@Alltec2233 2 года назад
Good info
@sayalikarale6125
@sayalikarale6125 Год назад
very helpful.thanks. you explained in easy n clear way
@LearningwithRohan
@LearningwithRohan Год назад
Happy Learning
@manjutharak
@manjutharak Год назад
Thanks for helping to others from your channel keep it up😀
@LearningwithRohan
@LearningwithRohan Год назад
Welcome! Check out my website talendpro.com and download my mobile app!
@inhlam5909
@inhlam5909 Год назад
Ways to find duplicates: 1. Group by and Having 2. Window function (cte, row number) 3. Analytical (case, when, lag)
@LearningwithRohan
@LearningwithRohan Год назад
Yes 👍
@aayushjoshi2097
@aayushjoshi2097 2 года назад
Hi Rohan, thank you for sharing the knowledge with such a great content. Your videos helped me for preparing the interviews, thank you for that as well. Following is the question that I am thinking about for a long time, please reply back if possible with a recommended solution - Suppose we have a target (file/table) having 120 columns/fields in it and apart from the primary/unique key columns, say around 70 fields can be update. Any number of fields from these 70 can be update in a single run. So how can we know due to which particular fields the update has occurred? or in other words, if we want to find only those fields which are changing its value from the previous run for a set of records. Thanks in advance
@LearningwithRohan
@LearningwithRohan 2 года назад
This is possible but with custom solution. Inside tmap you need to lookup against target first and then compare values, if something is changed, you may want to capture the field name and keep appending and add it to a custom column at the end or capture it a separate table..
@aayushjoshi2097
@aayushjoshi2097 2 года назад
@@LearningwithRohan "Comparing the main and lookup fields in tMap is feasible only when there is 20-30 or may 50 fields. But if the no.of fields needs to compare is more than that it will be difficult to apply these many conditions manually". This type of replies I had got in past during my interviews so I thought there might be some other ways as well to do this. But I don't know if we have anything else to do here. BTW Thank you very much Rohan 😊 Please keep posting such meaningful and learning contents for the users.
@vijaykumar-kc7dt
@vijaykumar-kc7dt 2 года назад
Can you post more videos on Talend on cloud environment.
@LearningwithRohan
@LearningwithRohan 2 года назад
Ya, more coming on talend
@TaRoKiKa
@TaRoKiKa 7 месяцев назад
Logic should build to identify each record having any duplication if so then skip those records instead of failing the job and dump those failed records in separate table . Can we achieve this in Talend using the components?
@LearningwithRohan
@LearningwithRohan 7 месяцев назад
Yes possible multiple ways - sort - aggregate - tmap.. download my app from talendpro.com
@beautifullectures
@beautifullectures 9 месяцев назад
Hi, how to reconcile quickly? And how to find out if the reference IDs are matching or not quickly?
@LearningwithRohan
@LearningwithRohan 8 месяцев назад
Download my mobile app from talendpro.com for free group chat and free resources
@divityvali8454
@divityvali8454 2 года назад
Can you make one mini project in Talend sir
@LearningwithRohan
@LearningwithRohan 2 года назад
Next month
@LearningwithRohan
@LearningwithRohan 2 года назад
I recommend everyone to get strong on SQL as well.. pls don’t neglect sql
@chandrakanthpadi
@chandrakanthpadi 7 месяцев назад
Can we do it by self join?
@LearningwithRohan
@LearningwithRohan 7 месяцев назад
Yes possible
@alagu1992
@alagu1992 Год назад
What is cte_src?
@LearningwithRohan
@LearningwithRohan Год назад
That’s the CTE block
@joshitharun
@joshitharun Год назад
How can we delete rows using CTE and rownum
@LearningwithRohan
@LearningwithRohan Год назад
Are you referring to sql server? Or mysql?
@joshitharun
@joshitharun Год назад
MySQL
@sarv-shreshth
@sarv-shreshth Год назад
Wow, loved it man. Superb way taught🫡❤
@LearningwithRohan
@LearningwithRohan Год назад
You’re welcome
Далее
If You Like My Outfit Then You Are Subscribed 👀
00:12
Using SQL to Select Records from Multiple Tables
10:32
DELETE DUPLICATE ROWS FROM A TABLE IN SQL || 4 ways
9:15