#sql

[@nikhilhimanshu9758]

row_number is better but nice try sir

[@saurabhshukla2605]

Hi this was a great video. But one suggestion for part one, instead of using case for country_id you can directly use ROW_NUMBER which does the same thing. Gives unique ID for each row.

[@dailylifeofadataengineer7742]

Thank you Saurbh, that's awesome

[@AtulSingh-be1jk]

Please make a video to create a procedure for it.

[@dailylifeofadataengineer7742]

Sure Atul

[@AtulSingh-be1jk]

Hi.. Suppose,i have a table 'A' with five child table namely 'B','C','D','E','F'. Now,i like to delete the records of 'A' directly without deleting the child table one by one. Here,the problem is that out of those five child tables one or more can have also child tables.So,it is very difficult to go one by one and delete the all child tables followed by parent table. Also,there is possibilities of adding one or more child table to any of those tables described above in later point of time.In that case my query which is developed at this moment will not work and i would get error of ''INTEGRITY CONSTRAINT VIOLATION''. Also,there is no provision of ''on delete cascade'' as per our available data model and also it can't be modified right now. So,please kindly help me to resolve the issue of deleting parent record without deleting the immediate child tables one by one and also the associated child tables of the immediate child tables if any one by one.

[@dailylifeofadataengineer7742]

Sure, I will create video in this very soon

[@AtulSingh-be1jk]

Thanks for the reply sir

[@chenmaykulkarni6886]

How can contact with you

[@dailylifeofadataengineer7742]

Hi Chenmay Please connect with me on LinkedIn www.linkedin.com/in/ankit-shrivastava-5262561a/