SQL Incremental data load | 3 ways to perform Upsert | Update else Insert| EXISTS | ROWCOUNT | MERGE

[@hv0032113]

Commendable efforts. Thank you. These are all really important topics that you cover. One of the best SQL channels on KZbin!

[@LearnatKnowstar]

Thank you so much for your support!

[@pranjalagrawal4167]

Thank you. Great efforts.

[@LearnatKnowstar]

Glad you liked it!

[@Beyondhorizons-i5z]

Another great video 👍

[@LearnatKnowstar]

Thank you for the encouragement !

[@kristyowens2284]

Clearly explained. Thank you.

[@LearnatKnowstar]

Thank you

[@vinaynampally1163]

By using CTRL + r, you can minimize the output query window. And please do a video of sql functions

[@LearnatKnowstar]

Thank you. Will be posting soon!

[@_indrid_cold_]

Really well done!

[@LearnatKnowstar]

Thanks a lot!

[@vijaydesai20]

nicely explained. Thank you

[@LearnatKnowstar]

Glad it was helpful!

[@andrewhofmann5453]

Love your videos, love your topics. Your lack of formatting triggers me though. :)

[@LearnatKnowstar]

Thank you. Will take better care from next time 🙂

[@vpnath75]

Very informative! Could you also do a video on using cursors?

[@LearnatKnowstar]

Thank you. Sure, will plan soon.

[@realheckbit]

I noticed you did not mention how many scans are done when using the merge statement. Is it more or less efficient than the previous 2 methods?

[@swethareddy-u8v]

how to get update and insert rows count while we are using merge sql in oracle

[@whitecrowuk575]

Cool

[@LearnatKnowstar]

Thank you

[@kumar-nn5jx]

Tq, i learn from this video

[@LearnatKnowstar]

Glad it was helpful

[@gshan994]

How to use merge statement to merge 2 tables

[@imammasum3918]

[@avinashc8146]

Good information

[@LearnatKnowstar]

Thank you!

[@mainlykanchan8740]

Ma'am please make a video on sql project for portfolio 🙏🏼

[@LearnatKnowstar]

Sure. Will plan something soon.

[@aperxmim]

With if you have a table to loop through, these examples are only checking 1 record not the whole table