Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> query
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
3 1 1 1 8 1 7 1
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 9Please sugget what would be query.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 29 2005 - 08:07:50 CST
![]() |
![]() |