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

Home -> Community -> Mailing Lists -> Oracle-L -> query

query

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Tue, 29 Mar 2005 08:04:07 -0500
Message-ID: <BAY106-F410D88F41900513D5D8617D3450@phx.gbl>


hi
I'm getting the output from following
select known_category_id, count(rowid) from ovt_recognized_categories where known_category_id in (3,1,8,7)
group by known_category_id ;

KNOWN_CATEGORY_ID COUNT(ROWID)
----------------- ------------

               1            1
               3            1
               7            1
               8            1

I want the out would be like
KNOWN_CATEGORY_ID COUNT(ROWID)
----------------- ------------
               3            1
               1            1
               8            1
               7            1

Following are sample data.

ROWNUM ROWID KNOWN_CATEGORY_ID
---------- ------------------ -----------------

        1 AAANmrAAcAAAY0wAAA               986
        2 AAANmrAAcAAAY0wAAB                 1
        3 AAANmrAAcAAAY0wAAC                 2
        4 AAANmrAAcAAAY0wAAD                 3
        5 AAANmrAAcAAAY0wAAE                 4
        6 AAANmrAAcAAAY0wAAF                 5
        7 AAANmrAAcAAAY0wAAG                 6
        8 AAANmrAAcAAAY0wAAH                 7
        9 AAANmrAAcAAAY0wAAI                 8
       10 AAANmrAAcAAAY0wAAJ                 9
Please sugget what would be query.
thanks
-Seema

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 29 2005 - 08:07:50 CST

Original text of this message

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