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

Home -> Community -> Usenet -> c.d.o.tools -> SQL question

SQL question

From: A Kydd <akydd_at_gpu.srv.ualberta.ca>
Date: 2000/07/14
Message-ID: <8knsvp$ghk$1@pulp.srv.ualberta.ca>#1/1

Alrighty, I have a view mediatype_count like so:

(varchar2)           (number)
MEDIATYPE               MCOUNT
-------------------- ---------
C++ code                     1
Java applet                  1
soya products                1
unix binary                  2

Now say I want a count of the mediatypes which have an mcount of 5. There aren't any, so I want the query to return a value of 0. I've tried and tried, but I can only get the "no rows selected" result. It seems to me that I have gotten "0" results on similar queries before, but I'm on a different system now. Any help would be greatly appreciated.

Thanks in advance,

-- 
	...Alan...

"Have you seen a rubix cube around lately??  Slinky?
 What's happening to our world?" --Tey Steenbergen
Received on Fri Jul 14 2000 - 00:00:00 CDT

Original text of this message

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