r/learnSQL • • Oct 08 '21

SQL Cheatsheet (Basics)

Post image
422 Upvotes

22 comments sorted by

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

1

u/Horkrux Nov 14 '21

Hey, wold you consider doing one that would be fit as a wallpaper? I know it is prolly a lot to ask, but I'd love to set it as Wallpaper on one of my screens to quickly find it whenever

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

u/[deleted] Oct 09 '21

Yes. I'll try add it in at some point :)

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

u/[deleted] Oct 09 '21

Yes I'll try add it in at some point :)

3

u/twentyfive_25 Oct 08 '21

Thanks for sharing! Have saved a copy for my learning :)

1

u/[deleted] Oct 09 '21

No problem :)

3

u/Bloodwolv Oct 08 '21

and saved

1

u/[deleted] Oct 09 '21

Great :)

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

3

u/[deleted] Oct 17 '21

Hi thanks :)

I used canva.com along with carbon.now.sh

And yeah already posted it on there!

2

u/welktickler Oct 08 '21

Thank you very much for sharing

1

u/[deleted] Oct 09 '21

No problem :)

2

u/I_am_Torok Oct 08 '21

Good job!

2

u/[deleted] Oct 09 '21

Thank you!

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

u/Dr_phil_Phil Sep 06 '22 edited Sep 06 '22

Thank you, this comes in really handy.

1

u/[deleted] Oct 05 '22

saved

1

u/Djintimidator Oct 19 '22

Awesome! Will for sure come in handy!

4

u/[deleted] 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.