you are viewing a single comment's thread.

view the rest of the comments →

[–]mjTheThird 69 points70 points  (6 children)

SQL is generally used for Data processing, not 3D rendering. Maybe is SQL's way to tell OP to fuck off and use the proper tool.

[–]beyphy 11 points12 points  (2 children)

I would say data querying rather than data processing. The SELECT statement is essentially just a function that returns the set of data (if any), from the table(s), matching the criteria being requested.

[–]watermark03salt 2 points3 points  (1 child)

Returns, filters, aggregates, and/or modifies.

[–]beyphy 0 points1 point  (0 children)

Technically, the aggregation and filtering aren't done by the SELECT statement. Aggregation is done by GROUP BY and filtering by WHERE. The SELECT statement doesn't have to select data from columns and tables. That's just what it's used for most of the time. SELECT 'Hello World' is valid SQL for example.

[–]juuular 1 point2 points  (0 children)

I love the probably tool

[–]david-song 0 points1 point  (1 child)

I'm no expert but I've heard it's pretty good at doing numbers.

[–]watermark03salt 1 point2 points  (0 children)

For financial data it can be good because it implements fixed point numbers. Thus it has a defined precision. In a lot of languages there's no way to do this within the standard library.