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

Home -> Community -> Usenet -> c.d.o.server -> Re: Relationals vs. Objects Databases I

Re: Relationals vs. Objects Databases I

From: Jeremy Rickard <Jeremy_at_SPAM.demon.co.uk>
Date: 1998/01/28
Message-ID: <FJeNlDA2S8z0EwwB@jbdr.demon.co.uk>#1/1

In article <34cf2984.2460559_at_news.fyi.net>, Karl & Betty Schendel <schendel_at_kbcomputer.com> writes

>Bzzt! Wrong challenge. You can do that one in SQL, although it will
>probably run like frozen dogshit.
>select product from prod_table p1
>where 100 <= (select count(*) from prod_table p2
> where p2.price > p1.price)
>
>What you can't do (without defining a bunch of auxilliary views)
>is stuff like aggregation with different restrictions on each column.

But don't forget that inline views (aka table expressions) are now possible in SQL.

-- 
Jeremy Rickard

(To email, change "SPAM" to "jbdr" in address.)
Received on Wed Jan 28 1998 - 00:00:00 CST

Original text of this message

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