Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> "GROUP BY" question

"GROUP BY" question

From: Chen, Baoshan <Baoshan.Chen_at_garmin.com>
Date: Mon, 21 Feb 2000 17:03:19 -0600
Message-ID: <74471DFD03A7D11191E000600852EC6F05A9BC8E@DALLAS>


Sorry for the simple question. How can I get the forth line (A or B) using SQL statements?

category count

   A              5
   B             10
A or B         15

The following statement seems not to work.

select category count(*) from collection_data group by category
having category = 'A' or category = 'B' Received on Mon Feb 21 2000 - 17:03:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US