Тёмный

Delete Duplicate Rows from SQL Table using 3 ways 

GetSet SQL
Подписаться 2 тыс.
Просмотров 22 тыс.
50% 1
ВидеоПоделитьсяСкачатьДобавить в

In This Tutorial you will learn how to Delete duplicate rows in SQL Server
GetsetSQL Blog: www.getsetsql.com
RU-vid Channel: / getsetsql
Facebook: / getsetsql
Quora: www.quora.com/Amitesh-Bi/
Twitter: / getsetsql
Twitter: / amiteshdba
LinkedIn Group: / 10541375
LinkedIn Profile: / amitesh-srivastava
Music: Music: www.bensound.com

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

 

28 июн 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 14   
@dshantanub27
@dshantanub27 Год назад
best explanation ever bro. You won't believe I was not understanding this concept untill I saw this video. TYSM bro
@sukumar44
@sukumar44 2 года назад
Important advice for everyone watching this video: Please don't use the temporary table way to delete duplicates. By any chance, if your session is timed out you will loose all your data(backup). I have seen this happening in live projects. It not a good practice to truncate your main tables either.
@Chadner
@Chadner 2 года назад
Thats what I thought too, even though it is the easier way it does feel reckless to just dump everything without a safe backup. What about creating a new real table with the same attributes, then copying the data to it and only then dropping the original table?
@relangirama
@relangirama Год назад
nice explanation
@movingcloud5253
@movingcloud5253 2 года назад
Nice one 👍👍👍👍👍❤️❤️❤️
@jeetendrasahani1428
@jeetendrasahani1428 2 года назад
when use insert into table _name select * from # table _name - it is showing error like not supply and match values
@shashanksingh3838
@shashanksingh3838 Год назад
it's throwing an error: Error Code: 1288. The target table remove_duplicate of the DELETE is not updatable
@karandholakia1555
@karandholakia1555 3 года назад
Which tool is this to run queries ?
@Amitesh.Shrivastava
@Amitesh.Shrivastava Год назад
SQL Server Management Studio
@RoarMaddy
@RoarMaddy 2 года назад
Can we use rowid to delete duplicate?
@GetSetSQL
@GetSetSQL Год назад
sure we can use rowid to delete duplicate records .. this can be achieved by using subquery or CTE
@user-vl4tp5sw2e
@user-vl4tp5sw2e 2 года назад
What is the application u use?? Thanks
@GetSetSQL
@GetSetSQL Год назад
Which?
@mettupallimuneendrareddy9753
@mettupallimuneendrareddy9753 Год назад
Waste
Далее
How to remove Duplicate Data in SQL | SQL Query to remove duplicate
37:31
How to remove Duplicate Data in SQL | SQL Query to remove duplicate
Просмотров 331 тыс.
How to Delete Duplicates in Production Environment | SQL Delete Duplicate Rows
21:35
How to Delete Duplicates in Production Environment | SQL Delete Duplicate Rows
Просмотров 10 тыс.
ИГРА НА 15 АЙФОН 🔥 #шортс #мем #бабич #shorts #trending #ytshorts
01:01
ИГРА НА 15 АЙФОН 🔥 #шортс #мем #бабич #shorts #trending #ytshorts
Просмотров 316 тыс.
This gadget is perfect for your kids on rainy days #parenting #parentingtips #lifehacks #gadgets
00:12
This gadget is perfect for your kids on rainy days #parenting #parentingtips #lifehacks #gadgets
Просмотров 8 млн
ЭКСТРЕМАЛЬНОЕ ОГРАБЛЕНИЕ ОСКАРА! КВИНКА и БАДАБУМЧИК ЗАСТУКАЛИ за ИЗМЕНОЙ?!
19:48
ЭКСТРЕМАЛЬНОЕ ОГРАБЛЕНИЕ ОСКАРА! КВИНКА и БАДАБУМЧИК ЗАСТУКАЛИ за ИЗМЕНОЙ?!
Просмотров 1,6 млн
РОДИТЕЛИ не ПУСКАЮТ МЕНЯ ГУЛЯТЬ 😝 ► SchoolBoy Runaway #2
16:43
РОДИТЕЛИ не ПУСКАЮТ МЕНЯ ГУЛЯТЬ 😝 ► SchoolBoy Runaway #2
Просмотров 123 тыс.
Table variable in SQL Server 2019 with examples
16:05
Table variable in SQL Server 2019 with examples
Просмотров 4,2 тыс.
DELETE DUPLICATE ROWS FROM A TABLE IN SQL || 4 ways
9:15
DELETE DUPLICATE ROWS FROM A TABLE IN SQL || 4 ways
Просмотров 201 тыс.
Oracle PL SQL interview question | SQL to Delete duplicate records
17:27
Oracle PL SQL interview question | SQL to Delete duplicate records
Просмотров 74 тыс.
How to Identify and Delete Duplicate Records in SQL | Easy Explanation with Real Time Scenarios
29:05
How to Identify and Delete Duplicate Records in SQL | Easy Explanation with Real Time Scenarios
Просмотров 23 тыс.
31 Delete duplicate records in SQL, keep the new records
9:02
31 Delete duplicate records in SQL, keep the new records
Просмотров 5 тыс.
CTE in SQL (Common Table Expression) | SQL WITH Clause | CTE Query Performance | Advanced SQL
55:39
CTE in SQL (Common Table Expression) | SQL WITH Clause | CTE Query Performance | Advanced SQL
Просмотров 94 тыс.
Part 1 How to find nth highest salary in sql
11:45
Part 1 How to find nth highest salary in sql
Просмотров 1,9 млн
How To Delete Duplicate Rows In a Table | SQL | Interview Preparation
8:10
How To Delete Duplicate Rows In a Table | SQL | Interview Preparation
Просмотров 24 тыс.
Temporary Table in SQL Server (Local & Global)
13:18
Temporary Table in SQL Server (Local & Global)
Просмотров 1,7 тыс.
How to delete duplicate records from a table in SQL | How to delete duplicate rows in SQL
11:34
How to delete duplicate records from a table in SQL | How to delete duplicate rows in SQL
Просмотров 107 тыс.
ИГРА НА 15 АЙФОН 🔥 #шортс #мем #бабич #shorts #trending #ytshorts
01:01
ИГРА НА 15 АЙФОН 🔥 #шортс #мем #бабич #shorts #trending #ytshorts
Просмотров 316 тыс.