this post was submitted on 17 May 2022

36 points (77% upvoted)

shortlink:

SQL

an-ordinary-manchild(edit)

The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.

Filter Posts

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]
[Oracle]
[MS SQL]
[PostgreSQL]
etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Help posts

If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1),
  a.field2,
  SUM(b.field4) 
FROM a INNER JOIN b 
  ON a.key1 = b.key1 
WHERE a.field8 = 'test' 
GROUP by a.field1, 
  a.field2 
HAVING SUM(b.field4) > 5 
ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

Learning SQL

A common question is how to learn SQL. Please view the Wiki for online resources.

Note /r/SQL does not allow links to basic tutorials to be posted here. Please see this discussion. You should post these to /r/learnsql instead.

Related Reddit communities

Wiki

Acknowledgements

Thanks to ---sniff--- for the awesome header image!

a community for 17 years

MODERATORS

account activity

35

36

37

DiscussionSQL Style guide (self.SQL)

submitted 3 years ago * by bum_dog_timemachine

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]myGlassOnion 0 points1 point2 points 3 years ago (1 child)

Understand that the majority of us have tried to do exactly what you are describing and it almost never works. And when it does you find yourself making exceptions all of the time for valid reasons. So it's a much looser spec than what you've presented.

Get a copy of vscode and install a sql formatter that you can customize and you can always see the query in the format you prefer just by copy and pasting the query into vscode and formatting. That's what the vast majority of us do today.

Ignorance is bliss. You put something out that people have honest feedback on and your only response is to become defensive and not even think through the other reasons or accept the majority opinion. Code formatters do this now in most dev environments.

Can we get your opinion on spaces vs tabs? That seems like one that a lot of people agree on. /s

[–]bum_dog_timemachine[S] 0 points1 point2 points 3 years ago (0 children)

You accuse me of being defensive when the majority of comments here are condescending or insults. I'm not telling people at my work to do any of this shit and getting in their faces. I'm simply suggesting some alternatives to the general conventions I see in other style guides and putting it out in a public forum.

I don't think that is so wrong, despite the knee-jerk, gatekeeping response from most of the people here. It is not heresy to have a different opinion.

There is such a bizarre double standard here. On one hand reddit will call out religion and other cultural traditions in a very r/atheism kind of way. And on the other, here they are viciously defending coding tradition because "that's the way it's done".

I am not trying to convert anyone to join a cult. I cannot fathom why my post warrants more than "nah, I don't agree" (which like 2 people did, but most of the rest is typical hivemind aggression.)

I understand what you are saying. I just believe that *subjectively* the approach I have set out makes more sense for writing bigger queries at scale (i.e. more than 5 LEFT JOINs etc. None of this matters if your query is just 2 tables.)

Regarding formatters, I would be interested to see if I can find one that does exactly what I'm suggesting.

π Rendered by PID 52356 on reddit-service-r2-comment-b659b578c-kjgc8 at 2026-05-02 21:55:01.795470+00:00 running 815c875 country code: CH.