Learning Subqueries

My Question is what is the best way to learn subqueries? And why are they referred to as dynamic queries? Thanks

why go through a lot of pain and RE invent the wheel !!!!
there are lots of "you tube videos" where people explain very very nicely with data and everything
please see a link below ... for sub queries
. hope this helps :slight_smile: :slight_smile:

1 Like

[1] that depends on the person. I prefer books / written material, for which Itzik Ben-Gans books are truly superb. If you prefer videos, there are lots out there, some taking far longer than others.

[2] Subquery and dynamic are not directly related, they are two different things. Perhaps you meant "correlated". A subquery can be correlated, but does not have to be.

1 Like