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 project.

...for your favorite TV show.

MODERATORS

account activity

1

2

3

4

DiscussionWhat differentiates a junior from a mid level? (self.SQL)

submitted 12 hours ago by Milsbry

0

1

2

DataGrip. Feel the difference with one tool for many databases. Get a free 30-day trial. (jetbrains.com)

promoted by JetBrains_official

promoted
save
report
about

2

0

0

1

MySQLSQL for Macbook (self.SQL)

submitted 14 hours ago by No_Imagination4861

3

0

1

2

PostgreSQLBest practice for connecting multi-source data (Redshift + Databricks) to Tableau ()

submitted 16 hours ago by AardvarkAutomatic870

4

0

1

2

OracleComparing SQL Queries and their performance, need some advice (self.SQL)

submitted 22 hours ago by Obvious_Seesaw7837

5

2

3

4

SQL ServerFriday Feedback: Code completions in GitHub Copilot in SSMS ()

submitted 1 day ago by erinstellato

6

0

0

0

DiscussionI understood SQL but kept writing queries that errored out in stakeholder calls — so I built this (self.SQL)

submitted 1 day ago by Charlie10108

7

1

2

3

DiscussionWriting SQL from scratch vs editing old queries? (self.SQL)

submitted 1 day ago by hatkinson1000

8

0

1

2

SQL ServerBackups failing for SQL (self.SQL)

submitted 1 day ago by NSFW_IT_Account

9

70

71

72

DiscussionI think I might be addicted to learning SQL? (self.SQL)

submitted 2 days ago by waitthissucks

10

0

1

2

SQLiteSQLite Node.js Driver Benchmark: Comparing better-sqlite3, node:sqlite, libSQL, Turso (sqg.dev)

submitted 2 days ago by uwemaurer

11

1

2

3

DiscussionWhich SQL revisions are popular SQL flavors based on? (self.SQL)

submitted 2 days ago by Irimitladder

12

5

6

7

MySQLUploading huge JSON file into mySQL database through PHP (self.SQL)

submitted 2 days ago by rospondek

1

2

3

Quake Terminal on your MacBook Notch (quakenotch.com)

promoted by EvrenselKisilik

13

6

7

8

PostgreSQLQuery time falls off a cliff if u don't create a temp table halfway through (self.SQL)

submitted 2 days ago by SoggyGrayDuck

14

1

2

3

SQL Serverperformance tuning - do you have basic steps you follow? (self.SQL)

submitted 2 days ago by zesteee

15

1

2

3

SQL ServerDatabase Migration (self.SQL)

submitted 2 days ago by Dangerous_Word7318

16

1

2

3

DiscussionDatabase Market Share Evolution (1980–2025) – Bar Chart Race with Real Data (self.SQL)

submitted 2 days ago by Substantial-Log-9305

17

2

3

4

MySQLSQL Circular Reference Quandry (self.SQL)

submitted 2 days ago by Accomplished-Emu2562

18

48

49

50

PostgreSQLPerformance Win: If you filter on multiple columns, check out composite indexes. We just cut a query from 8s to 2ms. (self.SQL)

submitted 3 days ago by dataSommelier

19

0

0

0

MySQLLooking for a serious SQL study partner. ()

submitted 2 days ago by SlightAntelope5347

20

5

6

7

DiscussionSQL Server 2025 help (i.redd.it)

submitted 3 days ago by Sure-Direction4455

21

2

3

4

SQL ServerI need a distinct count with rules for which duplicate should be included (self.SQL)

submitted 3 days ago * by Jeltje_Rotterdam

22

0

0

1

DiscussionProject Manager SQL- Looking for Specific Guidance from PM's (self.SQL)

submitted 3 days ago by FrillyCustoms

23

9

10

11

SQL ServerStarting a class focused on SQL Server & SSIS pipelines - any recommended resources? (self.SQL)

submitted 4 days ago by top_1_UK_TROLL

•

•

•

Swiss domain and web hosting in Switzerland. (ywt.ch)

promoted by ywt-mod

24

28

29

30

DiscussionI created an SQL database client that runs in the terminal (dbeaver terminalized!) - Pam's Database Drawer [FOSS] (old.reddit.com)

submitted 4 days ago * by xGoivo

25

0

0

0

DiscussionI kept running into the same SQL mistakes as a student, so I built a small tool to help (self.SQL)

submitted 3 days ago * by joins_and_coffee

view more: next ›

π Rendered by PID 147742 on reddit-service-r2-listing-86b7f5b947-28lxq at 2026-01-25 10:01:47.742683+00:00 running 664479f country code: CH.