| | Aliasing Table and Column Names in the FROM Clause (modern-sql.com) |
|
1 point by okket on March 11, 2018 | past
|
|
| | Pivot – Rows to Columns (modern-sql.com) |
|
145 points by mooreds on Feb 5, 2018 | past | 40 comments
|
|
| | Three-Valued Logic (modern-sql.com) |
|
138 points by okket on Dec 14, 2017 | past | 72 comments
|
|
| | IS DISTINCT FROM – A comparison operator that treats two NULL values as the same (modern-sql.com) |
|
2 points by okket on Dec 6, 2017 | past
|
|
| | NULL in SQL: Indicating the Absence of Data (modern-sql.com) |
|
1 point by kawera on Dec 2, 2017 | past
|
|
| | SQL Pivot in All Databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, … (modern-sql.com) |
|
2 points by okket on Oct 9, 2017 | past
|
|
| | Modern SQL: Extract – Get a Field from a DATE or TIME Value (modern-sql.com) |
|
1 point by MarkusWinand on Sept 21, 2017 | past
|
|
| | Modern SQL: EXTRACT Components from a Date or Time in MySQL, Oracle, PostgreSQL (modern-sql.com) |
|
2 points by okket on Sept 20, 2017 | past
|
|
| | Literate SQL (modern-sql.com) |
|
221 points by mshenfield on June 25, 2017 | past | 95 comments
|
|
| | What's New in SQL:2016 (modern-sql.com) |
|
4 points by okket on June 15, 2017 | past
|
|
| | SQL:2016 got listagg: turning rows into delimited strings (modern-sql.com) |
|
1 point by MarkusWinand on April 6, 2017 | past
|
|
| | The SQL:2016 Standard Introduced MATCH_RECOGNIZE: Regular Expressions Over Rows (modern-sql.com) |
|
1 point by MarkusWinand on March 23, 2017 | past
|
|
| | The performance impact of SQL WITH clause on all major relational databases (modern-sql.com) |
|
3 points by lukaseder on Feb 2, 2017 | past
|
|
| | How to PIVOT in SQL (modern-sql.com) |
|
3 points by mariuz on Jan 24, 2017 | past
|
|
| | Pivot in pure SQL, with an application to the entity-attribute-value model (modern-sql.com) |
|
6 points by MarkusWinand on June 28, 2016 | past
|
|
| | The SQL filter clause: selective aggregates (modern-sql.com) |
|
138 points by MarkusWinand on May 30, 2016 | past | 47 comments
|
|
| | Literate SQL (modern-sql.com) |
|
68 points by based2 on Dec 19, 2015 | past | 36 comments
|
|
| | Literate SQL (modern-sql.com) |
|
4 points by MarkusWinand on Dec 14, 2015 | past
|
|
| | Modern SQL: With – Organize Complex Queries (modern-sql.com) |
|
165 points by MarkusWinand on Nov 24, 2015 | past | 61 comments
|
|
| | Modern SQL (modern-sql.com) |
|
3 points by calpaterson on Oct 1, 2015 | past
|
|
| | Modern SQL (modern-sql.com) |
|
6 points by craigkerstiens on Sept 30, 2015 | past
|
|
