Difference between revisions of "Template:Hacks Ref"
Jump to navigation
Jump to search
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[SQL HACKS]] | <div class= 'tutlist'> | ||
<div class = 'fc'>[[Hacks Reference|SQL HACKS]]</div> | |||
<p>[[Subquery_and_JOIN |Hack 10 Converting subqueries into joins]]</p> | <p>[[Subquery_and_JOIN |Hack 10 Converting subqueries into joins]]</p> | ||
<p>[[Subquery_and_JOIN2 |Hack 11 Converting aggregate subqueries into joins]]</p> | <p>[[Subquery_and_JOIN2 |Hack 11 Converting aggregate subqueries into joins]]</p> | ||
| Line 6: | Line 7: | ||
<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 and combining columns]]</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> | ||
| Line 17: | Line 18: | ||
<p>[[Combine_queries |Hack 70 Combine your queries]]</p> | <p>[[Combine_queries |Hack 70 Combine your queries]]</p> | ||
<p>[[Subset |Hack 72 Extract a subset of the results]]</p> | <p>[[Subset |Hack 72 Extract a subset of the results]]</p> | ||
<p>[[Range |Hack 78 Break it down by Range]]</p> | <p>[[Range |Hack 78 Break it down by Range]]</p> | ||
<p>[[Test_subquery |Hack 88 Test two values from a subquery]]</p> | <p>[[Test_subquery |Hack 88 Test two values from a subquery]]</p> | ||
<p>[[Stop_queries |Hack 98 Find and stop long running queries]]</p> | <p>[[Stop_queries |Hack 98 Find and stop long running queries]]</p> | ||
<p>[[SQL_from_webpage |Hack 100 Run SQL from a Web Page]]</p> | <p>[[SQL_from_webpage |Hack 100 Run SQL from a Web Page]]</p> | ||
</div> | |||
Latest revision as of 13:09, 8 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 and combining columns
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 78 Break it down by Range
Hack 88 Test two values from a subquery