~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/having.rst

Committer: Lee Bieber
Date: 2011-01-15 03:08:27 UTC
mfrom: (1994.5.38 doc)
mto: This revision was merged to the branch mainline in revision 2087.
Revision ID: kalebral@gmail.com-20110115030827-0h9s99kiknrmt9ti

Merge Stewart - some documentation clean up

files modified:
docs/aggregatefunctions.rst

docs/alter_table.rst

docs/analyze.rst

docs/check.rst

docs/columntypes.rst

docs/commit.rst

docs/create_index.rst

docs/data_dictionary.rst

docs/date_time_data_types.rst

docs/dml.rst

docs/drop_index.rst

docs/drop_schema.rst

docs/dynamic.rst

docs/groupby.rst

docs/having.rst

docs/insert.rst

docs/join.rst

docs/locks.rst

docs/logging.rst

docs/numeric_data_types.rst

docs/orderby.rst

docs/queries.rst

docs/rename.rst

docs/replace.rst

docs/replication.rst

docs/savepoints.rst

docs/scalarfunctions.rst

docs/show.rst

docs/start_transaction.rst

docs/storage_engines.rst

docs/string_data_types.rst

docs/tables.rst

docs/transactional.rst

docs/truncate.rst

docs/update.rst

docs/uuid_data_type.rst

docs/variables.rst

docs/where.rst

Show diffs side-by-side

added added

removed removed

docs/having.rst

**SQL HAVING Example**

Take a look at the "Activities" table:

+---------+--------------+--------------+-------------+----------+

+=========+==============+==============+=============+==========+

| 1 |2011-01-02 | Sport |45 |131 |

+---------+--------------+--------------+-------------+----------+

| 2 |2011-01-02 | Art |10 |256 |

+---------+--------------+--------------+-------------+----------+

| 3 |2011-01-02 | Music |25 |022 |

+---------+--------------+--------------+-------------+----------+

| 4 |2011-01-02 | Food |125 |022 |

+---------+--------------+--------------+-------------+----------+

| 5 |2011-01-03 | Music |40 |131 |

+---------+--------------+--------------+-------------+----------+

| 6 |2011-01-03 | Food |20 |175 |

+---------+--------------+--------------+-------------+----------+

+=========+==============+==============+=============+==========+

| 1 |2011-01-02 | Sport |45 |131 |

+---------+--------------+--------------+-------------+----------+

| 2 |2011-01-02 | Art |10 |256 |

+---------+--------------+--------------+-------------+----------+

| 3 |2011-01-02 | Music |25 |022 |

+---------+--------------+--------------+-------------+----------+

| 4 |2011-01-02 | Food |125 |022 |

+---------+--------------+--------------+-------------+----------+

| 5 |2011-01-03 | Music |40 |131 |

+---------+--------------+--------------+-------------+----------+

| 6 |2011-01-03 | Food |20 |175 |

+---------+--------------+--------------+-------------+----------+

In order to find if any users have spent more than $100 on recreational activities, use the following SQL statement: ::

The result-set will look like this:

====== ===============

userID SUM(OrderPrice)

====== ===============

022 150

====== ===============

userID SUM(OrderPrice)

====== ===============

022 150

====== ===============

Now we want to find if userIDs "131", "256", or "175" spent less than $50 on Activities.

The result-set would be:

====== ===============

userID SUM(OrderPrice)

====== ===============

userID SUM(OrderPrice)

====== ===============

256 10

175 20

====== ===============

Older »