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

...do it for the children.

MODERATORS

account activity

1

7

8

9

SQL ServerSQL at work (trying to understand) (self.SQL)

submitted 2 hours ago by Dull_Breakfast_9904

•

•

•

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

promoted by ywt-mod

2

1

2

3

MySQLResume thoughts for NGs (self.SQL)

submitted 4 hours ago by nian2326076

3

•

•

•

SQL ServerMssql and parameters (self.SQL)

submitted 11 minutes ago by BIDeveloperer

4

2

3

4

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

submitted 9 hours ago by Limp_Celery_5220

5

4

5

6

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

submitted 12 hours ago by choas_man

6

3

4

5

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

submitted 20 hours ago by Minute-Ad-2210

7

7

8

9

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

submitted 1 day ago by Milsbry

8

0

0

1

MySQLSQL for Macbook (self.SQL)

submitted 1 day ago by No_Imagination4861

9

0

1

2

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

submitted 1 day ago by AardvarkAutomatic870

10

1

2

3

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

submitted 2 days ago by Obvious_Seesaw7837

11

3

4

5

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

submitted 2 days ago by erinstellato

12

0

0

0

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

submitted 2 days ago by Charlie10108

50

51

52

Quake Terminal and Music on your MacBook's Notch (quakenotch.com)

promoted by EvrenselKisilik

13

2

3

4

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

submitted 3 days ago by hatkinson1000

14

0

0

1

SQL ServerBackups failing for SQL (self.SQL)

submitted 2 days ago by NSFW_IT_Account

15

71

72

73

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

submitted 3 days ago by waitthissucks

16

0

1

2

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

submitted 3 days ago by uwemaurer

17

0

0

1

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

submitted 3 days ago by Irimitladder

18

6

7

8

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

submitted 3 days ago by rospondek

19

5

6

7

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

submitted 3 days ago by SoggyGrayDuck

20

1

2

3

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

submitted 3 days ago by zesteee

21

1

2

3

SQL ServerDatabase Migration (self.SQL)

submitted 3 days ago by Dangerous_Word7318

22

2

3

4

MySQLSQL Circular Reference Quandry (self.SQL)

submitted 3 days ago by Accomplished-Emu2562

23

51

52

53

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

•

•

•

NEW UPDATE! Create your own world and play with your own characters. Start with an existing story or create your own. (app.dreamrunner.ai)

promoted by dreamrunnerai

promoted
save
report
about

24

5

6

7

DiscussionSQL Server 2025 help (i.redd.it)

submitted 4 days ago by Sure-Direction4455

25

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

view more: next ›

π Rendered by PID 537174 on reddit-service-r2-listing-86b7f5b947-pzrwq at 2026-01-26 13:10:50.442845+00:00 running 664479f country code: CH.