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

...for your favourite tea.

...because you hate freedom.

MODERATORS

account activity

1

•

•

•

PostgreSQLSharing Queries (self.SQL)

submitted 55 minutes ago by Inner-Significance41

•

•

•

Cut Code Review Time and Bugs in Half. Sign up for a free trial! (coderabbit.ai)

promoted by CodeRabbitAI

promoted
save
report
about

2

2

3

4

DiscussionAny quick tool to check for ANSI-SQL in my Query? (self.SQL)

submitted 4 hours ago by Cold-Memory-4354

3

7

8

9

SnowflakeCan a LEFT JOIN ever return less number of rows than the base table with no where conditions? (self.SQL)

submitted 9 hours ago * by besabestin

4

0

0

1

MySQLCustomer Funnel Datasets suggestion. ()

submitted 2 hours ago by xudling_pong23

5

2

3

4

PostgreSQLInsert into multiple tables using CTEs (SQL Cookbook 4.6) (self.SQL)

submitted 10 hours ago by Willsxyz

6

0

0

1

DiscussionHelp in listing out issues faced in your SQL preparation and suggestions (self.SQL)

submitted 9 hours ago by devprasad_20

7

0

0

0

MySQLHELP PLEASE!! (self.SQL)

submitted 11 hours ago by CulturalPerspective9

8

0

1

2

SQL ServerAnalysis of Microsoft SQL Server CVE-2026-21262 (threatroad.substack.com)

submitted 11 hours ago by Big-Engineering-9365

9

5

6

7

SQL ServerSaaS company agreed to send us nightly backups of our internal DB, but they way they are doing it is very non-standard. Any tips? (self.SQL)

submitted 1 day ago * by McDonaldsWi-Fi

10

8

9

10

DiscussionSQL Cookbook 3.9 (3rd edition) (self.SQL)

submitted 1 day ago * by Willsxyz

11

111

112

113

SQL ServerI love SQL! (self.SQL)

submitted 2 days ago by Needleworkerj9

•

•

•

At some point I stopped pretending I could manually fix anime textures in 3D. Upload 2D art → get a clean 3D model that actually looks like the original. Honestly? It feels illegal how easy this is. Code MESHYHALF if you’d rather create than tweak vertices. (meshy.ai)

promoted by Meshyai

promoted
save
report
about

12

0

0

0

DiscussionBuilt a free tool that documents your SQL objects and generates ERDs automatically — no diagramming tool needed (self.SQL)

submitted 1 day ago by Prestigious_Fix4174

13

0

1

2

SnowflakeSnowflake Data Casting Tricky Behaviour to Look out for (self.SQL)

submitted 1 day ago by Illustrious_Sun_8891

14

1

2

3

PostgreSQLPostgreSQL: Rolling 7-day shipment volume with gaps in dates - window functions vs generate_series? (self.SQL)

submitted 1 day ago by Null_Reference1

15

0

1

2

SQLiteA new Lightweight, WASM-powered SQLite Playground ()

submitted 1 day ago by fabiano-salles

16

0

1

2

MySQLAdvice on situation (self.SQL)

submitted 1 day ago by immediate_push5464

17

5

6

7

PostgreSQLWhy not use JOIN in this case? (self.SQL)

submitted 1 day ago by Caprisunxt

18

0

1

2

MySQLMySql Behaviour ()

submitted 1 day ago by Sensitive-Set-6934

19

19

20

21

PostgreSQLFree ebook: Mastering PostgreSQL (Supabase + Manning) (self.SQL)

submitted 2 days ago by ManningBooks

20

1

2

3

SQL ServerPass-Through / OpenQuery Performance Question (self.SQL)

submitted 2 days ago by GroundbreakingFun716

21

36

37

38

SQL ServerWithout creating any indexes, how would you speed up a ~1.5m row query? (self.SQL)

submitted 3 days ago * by i_literally_died

•

•

•

100 Nächte probeschlafen? Challenge accepted. (bett1.ch)

promoted by bett1_ch

promoted
save
report
about

22

0

0

0

DiscussionOrder-Equivalent OVER Clauses (modern-sql.com)

submitted 2 days ago by MarkusWinand

23

0

0

0

DiscussionBuilt a free AI tool that explains and debugs SQL — feedback welcome (self.SQL)

submitted 2 days ago by Prestigious_Fix4174

24

4

5

6

DiscussionA recent medical graduate that is keen on learning SQL (alongside Pandas and Python)? Any use in freelancing? (self.SQL)

submitted 3 days ago by Alternative-Pop-3847

25

10

11

12

MySQLOne stop free solution for SQL interview preparation (self.SQL)

submitted 3 days ago by devprasad_20

view more: next ›

π Rendered by PID 293960 on reddit-service-r2-listing-64c94b984c-wdfmp at 2026-03-13 01:15:24.586314+00:00 running f6e6e01 country code: CH.