aboutsummaryrefslogtreecommitdiffstats
path: root/guides/source/active_record_querying.textile
diff options
context:
space:
mode:
authorBertrand Chardon <bertrand.chardon@gmail.com>2012-04-13 12:08:03 -0700
committerBertrand Chardon <bertrand.chardon@gmail.com>2012-04-13 12:08:03 -0700
commit418fb91269fe1114f9b8f170ff85e1ea851b8d0c (patch)
tree622641c3e8fe179896d5142aa7c105d493031392 /guides/source/active_record_querying.textile
parent38148a0642a998613f20849ea6a34803f8f3429d (diff)
downloadrails-418fb91269fe1114f9b8f170ff85e1ea851b8d0c.tar.gz
rails-418fb91269fe1114f9b8f170ff85e1ea851b8d0c.tar.bz2
rails-418fb91269fe1114f9b8f170ff85e1ea851b8d0c.zip
SQL query formatting
Reformatted two SQL queries in Section 6) and 7) to avoid horizontal scrolling where possible.
Diffstat (limited to 'guides/source/active_record_querying.textile')
-rw-r--r--guides/source/active_record_querying.textile9
1 files changed, 7 insertions, 2 deletions
diff --git a/guides/source/active_record_querying.textile b/guides/source/active_record_querying.textile
index de55401c1f..06d0aa4f74 100644
--- a/guides/source/active_record_querying.textile
+++ b/guides/source/active_record_querying.textile
@@ -539,7 +539,9 @@ And this will give you a single +Order+ object for each date where there are ord
The SQL that would be executed would be something like this:
<sql>
-SELECT date(created_at) as ordered_date, sum(price) as total_price FROM orders GROUP BY date(created_at)
+SELECT date(created_at) as ordered_date, sum(price) as total_price
+FROM orders
+GROUP BY date(created_at)
</sql>
h3. Having
@@ -555,7 +557,10 @@ Order.select("date(created_at) as ordered_date, sum(price) as total_price").grou
The SQL that would be executed would be something like this:
<sql>
-SELECT date(created_at) as ordered_date, sum(price) as total_price FROM orders GROUP BY date(created_at) HAVING sum(price) > 100
+SELECT date(created_at) as ordered_date, sum(price) as total_price
+FROM orders
+GROUP BY date(created_at)
+HAVING sum(price) > 100
</sql>
This will return single order objects for each day, but only those that are ordered more than $100 in a day.