Re: complex SQL ?

From: DA Morgan <>
Date: Fri, 12 Dec 2008 11:55:51 -0800
Message-ID: <>

Jazz wrote:
> I figured it out, sorry, it is not very complex at all,
> SELECT * FROM table t where t.est < t.real;
> or also using HAVING clause somehow...

Glad you solved it ... but a couple of pointers.

  1. HAVING clause is filtering on groups created by GROUP BY
  2. ID is a reserved word
  3. REAL is a reserved word

FROM v$reserved_words
WHERE keyword = '<your_word_here>';

Is a valuable query to learn.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Dec 12 2008 - 13:55:51 CST

Original text of this message