Difference between revisions of "Template:Hacks Ref"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
<p>[[Multiply_sets |Hack 24 Multiply Across a Result Set]]</p> | <p>[[Multiply_sets |Hack 24 Multiply Across a Result Set]]</p> | ||
<p>[[Running_Total |Hack 25 Keep a running total]]</p> | <p>[[Running_Total |Hack 25 Keep a running total]]</p> | ||
<p>[[Credit_debit |Hack 25.5 | <p>[[Credit_debit |Hack 25.5 Splitting a column into two and combining two columns into one.]]</p> | ||
<p>[[Forgotten_rows |Hack 26 Include the rows your JOIN forgot]]</p> | <p>[[Forgotten_rows |Hack 26 Include the rows your JOIN forgot]]</p> | ||
<p>[[Maximum |Hack 30 Calculate the maximum/minimum of two fields]]</p> | <p>[[Maximum |Hack 30 Calculate the maximum/minimum of two fields]]</p> | ||
Revision as of 14:40, 2 August 2012
Hack 10 Converting subqueries into joins
Hack 11 Converting aggregate subqueries into joins
Hack 16 Search for a String across columns
Hack 24 Multiply Across a Result Set
Hack 25.5 Splitting a column into two and combining two columns into one.
Hack 26 Include the rows your JOIN forgot
Hack 30 Calculate the maximum/minimum of two fields
Hack 33 Get values and subtotals in one shot
Hack 50 Combine tables containing different data
Hack 51/52 Display rows as columns
Hack 55 Import Someone Else's Data
Hack 62 Issue Queries Without Using a Table
Hack 63 Generate rows without tables
Hack 72 Extract a subset of the results
Hack 74 Compare and synchronize Tables
Hack 78 Break it down by Range
Hack 88 Test two values from a subquery