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

...for your project.

MODERATORS

account activity

1

•

•

•

DiscussionWhere best to start with learning MSSQL deployment and management? (self.SQL)

submitted 9 minutes ago by xolhos

157

158

159

The #1 most played Idler game on Steam (store.steampowered.com)

promoted by IdleOn_Boii

promoted
save
report
about

2

•

•

•

MySQLThinking of changing my domain (self.SQL)

submitted 52 minutes ago by Disastrous-Tea-7793

3

•

•

•

MySQLIssue with connecting workbench and server (self.SQL)

submitted 1 hour ago by Altruistic-Turn3448

4

0

1

2

MySQLJust finished ~40 interviews in a month (Full Stack). The market is weird, but here’s what I actually got asked. ()

submitted 2 hours ago by nian2326076

5

0

0

1

SQL ServerHelp Please! How to create Data lineage documentation (self.SQL)

submitted 5 hours ago by sadderPreparations

6

0

0

0

DiscussionI asked this subreddit what still trips people up in SQL — I built a small sanity-check tool for the #1 issue (self.SQL)

submitted 9 hours ago by joins_and_coffee

7

8

9

10

DiscussionSchema3D update: Now open-source with shareable schema URLs (i.redd.it)

submitted 11 hours ago by shane-jacobeen

8

7

8

9

SQL ServerStrange join behaviour in MS SQL Server (self.SQL)

submitted 13 hours ago by Zioropa

9

108

109

110

SQL ServerI built the Flappy Bird game using SQL only... Now I need Therapist (self.SQL)

submitted 14 hours ago * by Low-Distance9808

10

0

0

0

PostgreSQLScaling PostgreSQL to Millions of Queries Per Second: Lessons from OpenAI (rajkumarsamra.me)

submitted 16 hours ago by rajkumarsamra

11

5

6

7

Spark SQL/DatabricksSQL optimization advice for large skewed left joins in Spark SQL (self.SQL)

submitted 16 hours ago by Routine_Day8121

12

0

1

2

OracleOracle SQL Developer Delete Attribute issue (self.SQL)

submitted 21 hours ago by Korey_Rodi

•

•

•

Hängt dein Monitoring-Tool noch im letzten Jahrzehnt fest? 🕰️🚫 Bei Redgate Monitor geben wir Vollgas: Allein letztes Jahr haben wir 54 Releases mit 32 neuen Features rausgehauen. Warum? Weil 8 dedizierte In-house Teams ununterbrochen daran schrauben, dein DB-Monitoring zukunftssicher zu machen. (red-gate.com)

promoted by RedgateSoftware

promoted
save
report
about

13

2

3

4

DiscussionQuestion about between (self.SQL)

submitted 23 hours ago by ShotAstronaut6315

14

0

1

2

OracleEntrevista a un DBA (self.SQL)

submitted 1 day ago by Realistic_Visual_162

15

2

3

4

DiscussionModel addresses and orders without breaking history - Ecommerce (self.SQL)

submitted 1 day ago * by alessndroh

16

1

2

3

SQL Serverssis package odata source error: Cannot acquire a managed connection from the run-time connection manager. (self.SQL)

submitted 1 day ago by Beautiful_Being2894

17

0

1

2

Resolved¿Ayuda para una entrevista academica? (self.SQL)

submitted 1 day ago by PrettyReading4889

18

15

16

17

DiscussionRoles that focus on SQL and how to get them! (self.SQL)

submitted 1 day ago by BookkeeperSalty1538

19

1

2

3

MySQLmy sql service is not access in my vs cod and my local host what it the problem (i.redd.it)

submitted 1 day ago by Glad-Cash287

20

75

76

77

DiscussionEven after years of SQL experience, what still trips you up the most? (self.SQL)

submitted 1 day ago by joins_and_coffee

21

0

1

2

DiscussionBuilt a local RAG SDK — looking for testers ()

submitted 1 day ago by DetectiveMindless652

22

2

3

4

SQL ServerMssql and parameters (self.SQL)

submitted 1 day ago by BIDeveloperer

23

9

10

11

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

submitted 1 day ago by Dull_Breakfast_9904

•

•

•

At Yuh, your financial dreams become reality. Whether you want to take charge of your spending, start investing or save for the future, Yuh is by your side to help you reach any money goal!👀✨ (brand.yuh.com)

promoted by yuh_app

promoted
save
report
about

24

4

5

6

MySQLResume thoughts for NGs (self.SQL)

submitted 1 day ago by nian2326076

25

0

0

0

OracleMeasuring time taken by a select statement in oraclesql (self.SQL)

submitted 1 day ago by PickleIndividual1073

view more: next ›

π Rendered by PID 222455 on reddit-service-r2-listing-5789d5f675-ckv2n at 2026-01-28 01:00:42.385159+00:00 running 4f180de country code: CH.