I just wanted to check if my alternative solution is also valid. It produced similar results as the attached solution. Is the 365 attached solution the "most correct" way to do this? If so, why? I know a few of the videos mention optimization, could my code be less efficient on a larger scale/table?

Hi Zach! Thanks for reaching out. Yes, your solution is valid. It depends on some factors like created indexes and the number of records. But for this DB your solution is optimized. Hope this helps. Best, Tsvetelin

Follow this topic

Zachary Roblyer

Last answered:

28 Nov 2022

Posted on:

27 Nov 2022

Resolved: Alternative solution

in SQL / SQL Subqueries with IN nested inside WHERE

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

28 Nov 2022

Helpful answer

Resolved: Alternative solution

Submit an answer

related questions