Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Relationals vs. Objects Databases I
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