count(*) in sql statement

From: Mark Citron <mcitron_at_hsc.usc.edu>
Date: 27 May 1994 08:41:31 -0700
Message-ID: <2s54bb$np7_at_hsc.usc.edu>

Is it possible to select two different counts in one statement? That is I have a list of dates, can I select the number of dates between dateA and dateB and also the number of dates between dateC and dateD? All on one line of output.

Any suggestions would be appreciated.
Mark Citron
Childrens Hospital Los Angeles

-- 
Mark Citron
mark_at_neurosci.usc.edu

Received on Fri May 27 1994 - 17:41:31 CEST

This message: [ Message body ]
Next message: John Gillespie: "Re: count(*) in sql statement"
Previous message: Rob E. Allan: "ProC like with VARCHAR is extremely slow in V7"
Next in thread: Heikki Rissanen: "Re: count(*) in sql statement"
Reply: John Gillespie: "Re: count(*) in sql statement"
Reply: Michael Ryan: "Re: count(*) in sql statement"
Reply: Heikki Rissanen: "Re: count(*) in sql statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message