It is advised that you use the search function in this subreddit or any other technology based subreddit to search for posts containing shortcuts for your OSĩ) Citations are required for YSKs regarding health and science related topics.ġ0) Don't shitpost. YSKs that are spamming websites, products and services will be dealt with at the discretion of the moderators and may result in action against the user posting the YSK.Ĩ) YSKs regarding computer shortcuts are no longer allowed as of June 2, 2014. The post must be a YSK as defined above.Ģ) Within your post you must include 'Why YSK' which should have an explicit statement of how it helps people improve on a task, skill, or ability as noted in the 1st Rule (and not your personal story).ģ) YSKs regarding Reddit, Facebook, Twitter or any other social media are NOT ALLOWED.Ĥ) YSKs with referral links to sites such as Dropbox or Amazon are NOT ALLOWED.ĥ) YSKs regarding ideas or concepts based in conspiracy will be removed at the discretion of the moderatorsĦ) YSKs that are a call to arms, which can be asking for support for charities, organizations or political parties WILL NOT BE ALLOWED.ħ) This subreddit is not the place to be self-advertising your websites, products and services. Rulesġ) Your post MUST begin with YSK and have appropriate flair. Look here for some thoughts about difference between a YSK and a TIL. YSKs are about self-improvement on how to do things, not for facts and figures, which is what /r/TodayILearned is for. I'll put up two simple examples of usage, which should make clear which kind of questions can be answered with (un)correlated subqueries:Įxample 1: get the number of 'open' orders, the number of 'waiting' orders and the open vs.A community to share tips and tricks that will help yourself improve on activities, skills and various other tasks. This is all fine and dandy, but what's the use? In other words, the subquery could be executed on its own. The definition (taken from O'Reilly's 'Learning SQL on SQL Server 2005') of a correlated subquery:Ī correlated subquery is an inner subquery whose information is referenced by the main, outer query such that the inner query may be thought of as being executed repeatedly.Īnd the definition of an uncorrelated subquery:Ī noncorrelated subquery is a subquery that is independent of the outer query. Many SQL questions on Devshed forums are easily solved using correlated and uncorrelated subqueries, but many don't know of them at all, or at least are not shure about the syntax, usage and performance implications, they sometimes rave about a stored procedure to loop and select other values.

How to gixen groups work