I Nailed the Deloitte Interview with This Tricky SQL Query!

[@Rebellionrider]

Odin School cohort starts soon - hubs.la/Q02PW0gm0

[@vru5696]

I request you to create detailed video on Data modelling and Query optimization (multiple ways)

[@sowmya6471]

Super...I don't know to use using clause with delete

[@kishorekumar4542]

Thanks for the information sharing

[@DeepikaJ-s6q]

Isn't this possible with Join itself?

[@davidwarshawsky1559]

Amazing video, I will pray though that you learn the shutter noise is so annoying

[@crickmoments3732]

Is this feature available in SQL Server.

[@sanandmath4127]

The DELETE command would delete the primary key record from the medicines_table, and that primary key would be gone. But now the stock_table would continue to have that record containing medicine_id (Foreign key), but there is no corresponding medicine_id (primary key) in the medicines_table. So will this DELETE statement succeed?

[@sanandmath4127]

Because of the Referential Integrity Violation.

[@sandhyarani2342]

How can we do it in sqlserver without cte

[@DeepikaJ-s6q]

isnt this possible with join operation itself?

[@nmaurya347]

Oracle doesnt allow delete with joins

[@debayanapanigrahi8121]

can we perform it in oracle ?

[@Rebellionrider]

unfortunately no! Oracle does not support DELETE with USING we have to go with CTE option there

[@vru5696]

​@@Rebellionrider request you to create detailed video on data modelling and optimization(multiple ways). Thank you

[@Ujjwalmishra-t1w]

I'm big fan of yours

[@Superhuman757]

But you are oracle guy and using sql syntax here.

[@chinmayamuduli468]

In this query stock table has foreign key for medicine if medicine id 1 comes multiple times and different. Expiry date if it has date of 2024-10-10 and other date is 2023-12-2 then medicine id 1 will be totally deleted

[@Rebellionrider]

Hi there, I was reviewing your comment and wanted to get your thoughts on something. You mentioned that the same medicine_id could appear multiple times in the stock table with different expiration dates. Could you help me understand why that would happen in a real-world scenario? For example, I’m wondering why a single medicine (with the same medicine_id) would have multiple expiry dates. Is it related to different batches or a specific stock management system? I just want to make sure I’m looking at this the right way. Thanks so much for your insight!

[@chinmayamuduli468]

In the stock table the medicine id is foreign key so that's why i think medicine id would be duplicate herre

[@aamirsohail3381]

Great video. Bad editing. Humble request, don't pop comments suggestions in b/w explaining query.

[@av98]

Start a startup bro. Don't pursue this rat race when you just need to redirect your efforts.

[@Rebellionrider]

You have no idea I seriously want to do that but I have no idea how to do that above that I have no one to support me.

[@Ujjwalmishra-t1w]

Tu nikal gya mat de