Simple SQL question

From: deanbrown3d <deanbrown3d_at_yahoo.com>
Date: 23 Jun 2005 07:03:19 -0700
Message-ID: <1119535399.854694.32740@g47g2000cwa.googlegroups.com>

Hi All,

I'm a beginner so please bear with me on this: I've been using the WITH clause in SELECT statements in 10g, and its a great. However, it cannot be used with UPDATEs, only SELECTs. Does anyone have any tips on how this could be emulated? For example if a subquery S is to be used twice or more, can it be created as some kind of variable, in a single SQL statement? It comes up when finding and then using the max or min values in a group of records.

Thanks,

Dean Received on Thu Jun 23 2005 - 09:03:19 CDT