SQL question

If I have a table like that

ID | ESTIMATED_VAL | REAL_VAL

xyz | 100 | 129
abc| 110 | 80

etc...

I want a query that returns all underestimated values, so:

if ESTIMATED_VAL < REAL_VAL return ID

Something like that. Do you know how to write the SQL query?

Many thanks

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...

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...

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...

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...

Jazz wrote:
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

SELECT COUNT(*)
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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Jazz wrote:
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

SELECT COUNT(*)
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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Jazz wrote:
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

SELECT COUNT(*)
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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Jazz wrote:
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

SELECT COUNT(*)
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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Jazz wrote:

SELECT ID FROM MyTableName (not supplied)
WHERE ESTIMATED_VAL < REAL_VAL

Unless I've missed something, this is quite easy.


Paul...


--