| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> beginners querying question
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
![]() |
![]() |