5
u/hshighnz Oct 08 '21 edited Oct 09 '21
Hi and thank you for your cheat sheet. Could you maby add window functions to the section of execution order?
2
2
u/chadbaldwin Oct 08 '21
This, I think "DISTINCT" may also be useful to throw in there.
I see people mix up the order of
DISTINCT TOP(N) ROW_NUMBER() OVER...all the time.1
3
3
3
u/The_Placard Oct 16 '21
This is great thanks!
May I know which program did you use to make the cheatsheet? Indesign? Photoshop?
Also Iām sure you would get a lot of love in r/coolguides
2
2
2
u/DataCakes12 Aug 22 '22
Not a cheat sheet but I recently came across a cool sql generator on Medium - after picking your transform and adding column headers it will give you copy/paste sql in different syntax check it: https://app.rasgoml.com/sql
1
1
1
4
Oct 20 '21
[removed] ā view removed comment
1
u/SATraveler_ Oct 12 '22
Thanks for this information, I tried some out and it is very helpful and easy to follow.
10
u/[deleted] Oct 08 '21
Put this together a little while ago. Might come in handy for some. Link to full PDF here:
https://github.com/ABZ-Aaron/CheatSheets