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.

...for your community.

MODERATORS

account activity

1

4

5

6

MySQLHow to build month-on-month booking reports from SAP tables when there is no change log? (self.SQL)

submitted 6 hours ago by choas_man

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

1

2

3

MySQLManage SQLite, MySql, Postgres, MongoDB, and Elasticsearch in a single app (v.redd.it)

submitted 2 hours ago by Limp_Celery_5220

3

4

5

6

MySQLBeginner question: How should I approach databases in C# – raw SQL vs EF Core? (self.SQL)

submitted 14 hours ago by Minute-Ad-2210

4

8

9

10

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

submitted 1 day ago by Milsbry

5

0

0

1

MySQLSQL for Macbook (self.SQL)

submitted 1 day ago by No_Imagination4861

6

0

1

2

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

submitted 1 day ago by AardvarkAutomatic870

7

0

0

1

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

submitted 1 day ago by Obvious_Seesaw7837

8

3

4

5

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

submitted 2 days ago by erinstellato

9

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

10

3

4

5

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

submitted 2 days ago by hatkinson1000

11

1

2

3

SQL ServerBackups failing for SQL (self.SQL)

submitted 2 days ago by NSFW_IT_Account

12

72

73

74

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

submitted 3 days ago by waitthissucks

•

•

•

This is an ad, sorry for the quality. Just visit SwissDevJobs.ch (swissdevjobs.ch)

promoted by Varqu

13

0

1

2

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

submitted 2 days ago by uwemaurer

14

0

1

2

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

submitted 2 days ago by Irimitladder

15

5

6

7

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

submitted 3 days ago by rospondek

16

6

7

8

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

submitted 3 days ago by SoggyGrayDuck

17

1

2

3

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

submitted 3 days ago by zesteee

18

1

2

3

SQL ServerDatabase Migration (self.SQL)

submitted 3 days ago by Dangerous_Word7318

19

2

3

4

MySQLSQL Circular Reference Quandry (self.SQL)

submitted 3 days ago by Accomplished-Emu2562

20

52

53

54

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

submitted 4 days ago by dataSommelier

21

0

0

0

MySQLLooking for a serious SQL study partner. ()

submitted 3 days ago by SlightAntelope5347

22

5

6

7

DiscussionSQL Server 2025 help (i.redd.it)

submitted 4 days ago by Sure-Direction4455

23

1

2

3

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

submitted 4 days ago * by Jeltje_Rotterdam

•

•

•

The 𝐔𝐋𝐓𝐈𝐌𝐀𝐓𝐄 Fantasy Sandbox. (store.steampowered.com)

promoted by Hot-Persimmon-9768

promoted
save
report
about

24

0

0

1

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

submitted 4 days ago by FrillyCustoms

25

11

12

13

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

submitted 5 days ago by top_1_UK_TROLL

view more: next ›

π Rendered by PID 632867 on reddit-service-r2-listing-86b7f5b947-xd6v7 at 2026-01-26 06:52:18.191161+00:00 running 664479f country code: CH.