Path: csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.lang.java.programmer Subject: Re: Where to put the return Date: Sun, 20 Aug 2017 19:30:37 +0200 Lines: 31 Message-ID: References: <87zib6zeup.fsf@munus.decebal.nl> <87y3qlnyvj.fsf@munus.decebal.nl> <87bmnbj09u.fsf@munus.decebal.nl> <877exzixum.fsf@munus.decebal.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Trace: individual.net UwdWAQilPRL/f927c5q8FAXwsDnMmxSXqyOn6Ws3ZEl464vs4= Cancel-Lock: sha1:QnkpT6zstPuQuvgL8KLxxDndOUQ= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 In-Reply-To: Content-Language: en-US Xref: csiph.com comp.lang.java.programmer:37328 On 20.08.2017 02:01, Arne Vajh=C3=B8j wrote: > On 8/19/2017 5:26 PM, Robert Klemme wrote: >> On 19.08.2017 15:48, Arne Vajh=C3=B8j wrote: >>> On 8/19/2017 9:35 AM, Robert Klemme wrote: >>>> You are missing the point: I was suggesting to use a query that uses= =20 >>>> aggregate function MIN() to select the needed value - if the schema = >>>> does support that. Since you did not disclose the view and table=20 >>>> definitions I cannot be more specific. >>> >>> MIN has to be there. It is basic SQL. >> I said "depending on schema" - not database product or SQL dialect. >=20 > I must be missing something. >=20 > If the database SQL supports MIN then I would expect it to always > be available independent of schema (both in the general meaning > and in the Oracle meaning of the term). Of course, but it depends on the schema whether MIN is required, an=20 elegant solution or cannot be used to query the desired value. Cheers robert --=20 remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/