complex SQL ?

From: Jazz <gery.ducatel_at_googlemail.com>
Date: Fri, 12 Dec 2008 07:04:33 -0800 (PST)
Message-ID: <f99fe64f-8f98-4519-b5ce-9f9ca2d0b259@q37g2000vbn.googlegroups.com>


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 Received on Fri Dec 12 2008 - 09:04:33 CST

Original text of this message