Re: complex SQL ?
Date: Fri, 12 Dec 2008 11:55:51 -0800
> 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.
- HAVING clause is filtering on groups created by GROUP BY
- ID is a reserved word
- REAL is a reserved word
WHERE keyword = '<your_word_here>';
Is a valuable query to learn.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Dec 12 2008 - 13:55:51 CST