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

Home -> Community -> Usenet -> comp.databases.theory -> beginners querying question

beginners querying question

From: Niko Schwarz <niko_at_schwarz.nu>
Date: Mon, 27 Aug 2001 18:06:47 +0200
Message-ID: <9mdr5r$1llpd$1@ID-42792.news.dfncis.de>

Hi folks,

I'm just trying to understand bout RDB and i seem to have a serious problem bout one task in my book...
ive got a table with several pricings of articles and an article number.

now find the pricing of the cheapest article seems pretty simple:

grp[|min ::= MIN(pricing)](Articles)

but how to get the number?

i found this one:

grp[|pricing ::= MIN(pricing)](Articles) join[pricing](Articles)

is this possible? or reasonable? isnt there another... you know, a cuter way to do that? if this would work, it would seem to me like the dirtiest hack on world =)

regards,

nick

-- 
Man is the only animal that can remain on friendly terms with the
victims he intends to eat until he eats them.
                -- Samuel Butler (1835-1902)
Received on Mon Aug 27 2001 - 11:06:47 CDT

Original text of this message

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