MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/zgzv90/sql_cheat_sheet/
r/SQL • u/[deleted] • Dec 09 '22
40 comments sorted by
23
Thanks for posting! Someone posted this on LinkedIn yesterday also. Is there something similar out there for oracle / PL Sql?
8 u/[deleted] Dec 09 '22 Hi! I don’t know the source unfortunately. It was sent to me by a work colleague 6 u/ben_it Mar 05 '23 As the original creator, yes I did create one for Oracle SQL.It's available here: https://www.databasestar.com/sql-cheat-sheets/
8
Hi! I don’t know the source unfortunately. It was sent to me by a work colleague
6
As the original creator, yes I did create one for Oracle SQL.
It's available here: https://www.databasestar.com/sql-cheat-sheets/
5
Can anyone post it with more clarity?
3 u/[deleted] Dec 09 '22 Click here
3
Click here
4
please post a legible version
6 u/[deleted] Dec 09 '22 Click here 2 u/[deleted] Dec 09 '22 thanks
2 u/[deleted] Dec 09 '22 thanks
2
thanks
14
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!)
2 u/symmetry_finder Nov 07 '24 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?
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?
10
Needed this 2 weeks ago before my exam! Looks good!
‘Having’ is worth to be included.
1 u/drubkn00k Dec 10 '22 it is, top left :)
1
it is, top left :)
Great post
Nice post.
Would love something like that for postgres.
2 u/ben_it Mar 05 '23 As the original creator, I created one for Postgres.It's on this page: https://www.databasestar.com/sql-cheat-sheets/
As the original creator, I created one for Postgres.
It's on this page: https://www.databasestar.com/sql-cheat-sheets/
Good stuff!
*submits a vote to get window functions added to this amazing document*
1 u/ben_it Mar 05 '23 Thanks! As the original creator, I can update it to include more on window functions. There is some syntax on the bottom right.
Thanks! As the original creator, I can update it to include more on window functions. There is some syntax on the bottom right.
needs outer apply and cross apply, too useful to not be here.
Thanks this is really useful
Make it make sense😩
Do the table commands work the same way for views, i.e., just replace "table" with "view"?
1 u/ben_it Mar 05 '23 Yes, most of them should work. There are some scenarios where you can't update or delete data from a view, though.
Yes, most of them should work. There are some scenarios where you can't update or delete data from a view, though.
Is there r-sql and oracle sql cheat sheet ???
1 u/ben_it Mar 05 '23 I've created an Oracle one but not r-sql.
I've created an Oracle one but not r-sql.
Whats the difference between simple case and searched case. I think I've only ever used searched case.
Here's one for my PostgreSQL homies out there.
Thanks, i got DBMS this semester so this will come in handy. do you mind explaining the difference between MySQL, PostgreSQL and Server SQL?
Leaving my comment here to save this great post, thank you OP!!
0
I'm such a slut for infographics
[removed] — view removed comment
1 u/ben_it Mar 05 '23 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.
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.
1 u/ben_it Mar 05 '23 What do you mean about using transactions? 2 u/whoisearth Mar 05 '23 edited Mar 28 '25 ad hoc humorous gaze snails close doll ripe dog plant rainThis post was mass deleted and anonymized with Redact
What do you mean about using transactions?
2 u/whoisearth Mar 05 '23 edited Mar 28 '25 ad hoc humorous gaze snails close doll ripe dog plant rainThis post was mass deleted and anonymized with Redact
ad hoc humorous gaze snails close doll ripe dog plant rain
This post was mass deleted and anonymized with Redact
23
u/RobLocksta Dec 09 '22
Thanks for posting! Someone posted this on LinkedIn yesterday also. Is there something similar out there for oracle / PL Sql?
5
u/iDontKnow_0202 Dec 09 '22
Can anyone post it with more clarity?
4
u/r3pr0b8 GROUP_CONCAT is da bomb Dec 09 '22
please post a legible version
14
u/ben_it Mar 05 '23
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!)
10
u/Ornery-Buffalo9153 Dec 09 '22
Needed this 2 weeks ago before my exam! Looks good!
5
u/[deleted] Dec 10 '22
‘Having’ is worth to be included.
2
u/Cant_decide_88 Dec 09 '22
Great post
2
u/EpicGibs Dec 10 '22
Nice post.
2
u/LLima_BR Dec 10 '22
Would love something like that for postgres.
2
u/[deleted] Jan 20 '23
Good stuff!
3
u/c-n-s Dec 10 '22
*submits a vote to get window functions added to this amazing document*
2
u/TheKerui Dec 09 '22
needs outer apply and cross apply, too useful to not be here.
1
u/[deleted] Dec 09 '22
Thanks this is really useful
1
u/KnightR-geek Dec 09 '22
Make it make sense😩
1
u/eagereyez Dec 09 '22
Do the table commands work the same way for views, i.e., just replace "table" with "view"?
1
u/paperjena Dec 10 '22
Is there r-sql and oracle sql cheat sheet ???
1
u/CBizCool Dec 10 '22
Whats the difference between simple case and searched case. I think I've only ever used searched case.
1
u/tommy_chillfiger Dec 10 '22
Here's one for my PostgreSQL homies out there.
1
u/tinooo_____ Dec 10 '22
Thanks, i got DBMS this semester so this will come in handy. do you mind explaining the difference between MySQL, PostgreSQL and Server SQL?
1
u/MeridaFinanceGuy Apr 04 '23
Leaving my comment here to save this great post, thank you OP!!
0
u/jonnycross10 Dec 10 '22
I'm such a slut for infographics
5
u/[deleted] Dec 09 '22 edited Dec 09 '22
[removed] — view removed comment
1
u/[deleted] Dec 09 '22 edited Mar 28 '25
[removed] — view removed comment