query
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Mar 2005 08:04:07 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
