Видео

You are very welcome 😁

How about LinkedIn? www.linkedin.com/in/douglaskline/ send me a connection request, then we can message directly.

You are very welcome!

Thank you👍

Wow, thanks for the positive feedback! Any topic I could cover that would help you out?

And this video so helpfull, Maybe do you also have approach to read and understand complex Query?

My first step in understanding code is to format it clearly.

Glad it was helpful!

Glad you liked it!

You should be able to do it with SQL Azure Edge, but you may have problems with a full SQL Server instance. There seems to be some unresolved issues with emulating Intel chips on the Apple chips. I tried to do a full SQL Server instance and failed, even with the latest versions of Docker and Rosetta.

@@DatabasebyDoug Yes thats crazy, could be that related to Windows ARM itself? Because ther are new Dell machines and others announced yesterday using Snapdragon® X Elite that suppose to be 58% faster than M3 but if that is ARM and same thing with SQL server issues then makes no sense for me to change from Intel processor

@@grupomexcomer you can only do that on UTM running on M chips but the perfomance is a bit compromised

Do you have any other Chanel or platform where you post more videos?

@@agermoune Hi, and thanks for asking! I'm going to start working on this channel again. Stay tuned, and let me know if you have any good video ideas that would help you!😀

​@@DatabasebyDoug@DatabasebyDoug I'm looking forward to your upcoming content (already subscribed!). I'm especially interested in videos covering: Inner Join vs. Left Join: when filtering should occur (ON vs. WHERE clause). Best practices for SQL syntax and formatting: any additional tips beyond what you've already shared would be great. Advanced SQL case scenarios I'm happy to pay for your content and would love to know if you offer any Udemy or LinkedIn courses. Thanks for your excellent teaching style!

Glad you liked it

Yes, they are the same. I had to try some examples to make sure that NULL handling was the same. But you might *need* to move the NOT away from the IN to do something like WHERE NOT (CategoryID IN (1,2,3) OR another_condition)

Thanks for the positive comments. I'm starting back to working on the channel, after life got in the way for a few years :-) Stay tuned, and let me know if you have any questions I can answer with a video.

I'm not sure I understand your question, but... The ORDER BY in the OVER clause has a different purpose than the ORDER BY for the whole SELECT query. The ORDER BY in the OVER is describing how to calculate RANK/ROW_NUMBER/DENSE_RANK. The ORDER BY at the end of the SELECT statement describes how to order the *results*.

@@DatabasebyDoug when you use sum it does a running count instead of ordering it

Glad it helped!

Sorry for the delayed response. You are right EXISTS is an operator that returns a boolean value. In the first "trivial" example, SELECT 17 always returns exactly one record, so EXISTS (SELECT 17) is always True. In the second example (correlated subquery), the subquery's results change based on a record in the outer query. So EXISTS() returns true or false, based on a record in the outer query, i.e., it is *correlated* with the outer query. You can phrase the same intended result using IN. In English, you could say "Categories where a Product exists in that category" or "Categories that are in a Category list drawn from the Products table". Both end up with the same result. I hope that helps!