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