Re: How to modify the view to set one field with min value of its field

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Thu, 01 Sep 2005 19:13:20 +0200
Message-ID: <fgdeh1dnd26f3r3k0qtjn02qj790stg288@4ax.com>

On Thu, 1 Sep 2005 14:53:21 +0200, "Robert Klemme" <bob.news_at_gmx.net> wrote:

>Then use that as an inline view in your main view's query and draw the min
>date value via a join on db_tran_id from there.
>
> robert

Or use the analytic function version of MIN, which probably will perform better. You must be 8.1.7 or higher though.

Jaap. Received on Thu Sep 01 2005 - 12:13:20 CDT

This message: [ Message body ]
Next message: pjbondi_at_SystemDatabase.com: "Accessing an Oracle 10g instance through an SSH tunnel using Oracle 10g Connection Manager on Windows"
Previous message: Mark Bole: "Re: Archive Processes"
In reply to: Robert Klemme: "Re: How to modify the view to set one field with min value of its field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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