SQL Merge Statement Tutorial A-Z | How to use Merge in SQL step by step

No video

SQL Merge Statement Tutorial A-Z | How to use Merge in SQL step by step

Рет қаралды 11,933

Күн бұрын

In this video we will understand the SQL merge statement. Using merge statement we can insert , update and delete data in a single statement.
script:
CREATE TABLE SourceProducts(
ProductID INT,
ProductName VARCHAR(50),
Price DECIMAL(9,2)
);
CREATE TABLE TargetProducts(
ProductID INT,
ProductName VARCHAR(50),
Price DECIMAL(9,2)
);
delete from SourceProducts;
INSERT INTO SourceProducts VALUES(1,'Table',90),(3,'Chair',70)
delete from TargetProducts;
INSERT INTO TargetProducts VALUES(1,'Table',100),(2,'Desk',180)
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #merge

Пікірлер: 22

@sakshijain3534 4 ай бұрын

This was asked to me in a recent interview, Thanks for clearing the concept.

@ankitbansal6 4 ай бұрын

Excellent!

@pranaykukadkar7092 4 ай бұрын

yrrr you are a gem the kind of explanation you give😀

@FazalAnsari-ju2zs 26 күн бұрын

Thank you so much Brother for the Kind Explanation..

@dasoumya 4 ай бұрын

Learnt something new today thank you Ankit for making these kind of videos 🙏🏻

@snehakulkarni1870 4 ай бұрын

I learned something new today. Thank you so much for sharing such insightful content.😊

@ankitbansal6 4 ай бұрын

Glad it was helpful!🙏

@ayushmi77al 4 ай бұрын

Totally new concept for me, thanks for sharing

@milindzuge906 4 ай бұрын

Thank you so much Ankit for such a beautiful content ❤❤

@ankitbansal6 4 ай бұрын

Thank you so much 😀

@AhmedDayyan-ub8in 2 ай бұрын

This is really helpful thank you

@ravisaxena1599 4 ай бұрын

Nice 😊

@thotakurapavanika7417 4 ай бұрын

Very helpful. Whats the realtime application of this statement?

@ankitbansal6 4 ай бұрын

For implementing scd type 1, 2 and 3

@vijaypalmanit 4 ай бұрын

Very common in loading data while performing ETL

@VinitaRanaSherawat Ай бұрын

@@ankitbansal6how is history maintained?

@ppenumarti 4 ай бұрын

Thanks!

@ankitbansal6 4 ай бұрын

Thank you 😊

@AAMIRKHAN1602 3 ай бұрын

Thanks for this but merge into can handle many other scenarios and it can get tricky

@Apna_tahlka_123 4 ай бұрын

Only if i learn sql can we got job reply jrur dena plj or plj video me thoda hindi me bhi smjhaya kro taki easily smjh aajae thanks i hope u reply soon

@sureshraina321 3 ай бұрын

can't we do something like this trunacte table target_table_name; insert into target_table select * from source_table; if we want to have all 3 features together. Seems weird but still asking

@aryabhatt5833 3 ай бұрын

Right. But, I think when we are dealing with tables having millions of records and only a hundreds need insert, update or delete, then merge makes more sense.