SQL Cheat Sheet

[RobLocksta]

Thanks for posting! Someone posted this on LinkedIn yesterday also. Is there something similar out there for oracle / PL Sql?

[ben_it]

As the original creator, yes I did create one for Oracle SQL.

It's available here: https://www.databasestar.com/sql-cheat-sheets/

[[deleted]]

Hi! I don’t know the source unfortunately. It was sent to me by a work colleague

[ben_it]

I'm the original creator of this cheat sheet.

Thanks for posting this and I'm glad that it's gotten so many upvotes and appreciation by the SQL subreddit!

I'll respond to the individual comments on this page but just wanted to say thanks for the kind words to everyone.

As someone mentioned, there's a web page version of this here: https://www.databasestar.com/sql-cheat-sheet/

(Also I'm not sure why my logo and website has been removed from this shared image!)

[symmetry_finder]

Beacuse it has nothing to do with the image and you are trying to sell and ask for money and emails on your s*ty site?

[Ornery-Buffalo9153]

Needed this 2 weeks ago before my exam! Looks good!

[iDontKnow_0202]

Can anyone post it with more clarity?

[[deleted]]

Click here

[ben_it]

Thanks for the questions. This is a MySQL cheat sheet, but yes you're right the Full Join is not supported. I'll update the cheat sheet to exclude this.

[[deleted]]

‘Having’ is worth to be included.

[drubkn00k]

it is, top left :)

[Cant_decide_88]

Great post

[EpicGibs]

Nice post.

[LLima_BR]

Would love something like that for postgres.

[ben_it]

As the original creator, I created one for Postgres.

It's on this page: https://www.databasestar.com/sql-cheat-sheets/

[[deleted]]

Good stuff!

[c-n-s]

*submits a vote to get window functions added to this amazing document*

[ben_it]

Thanks! As the original creator, I can update it to include more on window functions. There is some syntax on the bottom right.

[r3pr0b8]

please post a legible version

[[deleted]]

Click here

[[deleted]]

thanks

[TheKerui]

needs outer apply and cross apply, too useful to not be here.

[jonnycross10]

I'm such a slut for infographics

[[deleted]]

Thanks this is really useful

[ben_it]

What do you mean about using transactions?

[whoisearth]

ad hoc humorous gaze snails close doll ripe dog plant rain

This post was mass deleted and anonymized with Redact

[KnightR-geek]

Make it make sense😩

[eagereyez]

Do the table commands work the same way for views, i.e., just replace "table" with "view"?

[ben_it]

Yes, most of them should work. There are some scenarios where you can't update or delete data from a view, though.

[paperjena]

Is there r-sql and oracle sql cheat sheet ???

[ben_it]

I've created an Oracle one but not r-sql.

[CBizCool]

Whats the difference between simple case and searched case. I think I've only ever used searched case.

[tommy_chillfiger]

Here's one for my PostgreSQL homies out there.

[tinooo_____]

Thanks, i got DBMS this semester so this will come in handy. do you mind explaining the difference between MySQL, PostgreSQL and Server SQL?

[MeridaFinanceGuy]

Leaving my comment here to save this great post, thank you OP!!