On Tue, 1 May 2007, Allan, Mark wrote:

Ok, so here's another question, how would I get the count of patients where the 
EVC and FVC > 2.0?

  COUNT * from SELECT ...

  There are several aggregate functions available in SQLite.

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to