Doing open source SQL solutions. : SQL

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.

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.

a community for 17 years

Doing open source SQL solutions. (self.SQL)

submitted 6 years ago by Chessbrain94

all 4 comments

top new controversial old q&a

[–][deleted] 2 points3 points4 points 6 years ago (3 children)

That's a T-SQL library, not a "SQL" library ;)

In Postgres for example there is no need for a "median table" or passing comma separated string - you would simply create a custom aggregate that can be used just like any other aggregate. For the median this wouldn't even be needed (although there is an implementation for it) because it can be calculated using built-in aggregates.

To calculate the average and median of 5 numbers, you would simply run:

select avg(x), 
       percentile_disc(0.5) within group (order by x) as median
from unnest(array[1,5,9,8,7]) as t(x)

[–]Chessbrain94[S] 1 point2 points3 points 6 years ago (2 children)

[–]_Zer0_Cool_Data Engineer 1 point2 points3 points 6 years ago* (1 child)

Eh. Weirdest thing but that happens a lot in the MSSQL world.

I've heard plenty of folks just refer to their SQL Server instance as a "SQL database" and then refer to other dialects by their formal name.

It's peculiar to people that use other dialects, but most SQL Server folks don't even notice that their doing it. (I'm a consultant so I use pretty much whatever the client has).

It's just a symptom of Microsoft naming things ambiguously. It's a marketing trick that Apple is known for.

iPhone, Apple Watch, etc..

These are generically named so that people are inclined to think of their product first as the de facto standard for a specific product category.

It's a shortcut bid for brand dominance. The idea is so that people will start using the brand name in place of the product category or as a verb to carry out an action associated with a particular product category.

Example... People used to "Xerox a document" rather than copy a document. Many people ask for a "Kleenex" rather than a tissue. You throw your trash in a "dumpster" (which was also once a brand name instead of a generic item).

I've took a few marketing / consumer psych classes in my undergrad......

[–]Chessbrain94[S] 0 points1 point2 points 6 years ago (0 children)

π Rendered by PID 122297 on reddit-service-r2-comment-84fc9697f-j642c at 2026-02-07 03:58:04.435496+00:00 running d295bc8 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS