complex SQL ?
Date: Fri, 12 Dec 2008 07:04:33 -0800 (PST)
If I have a table like that
ID | ESTIMATED_VAL | REAL_VAL
xyz | 100 | 129
abc| 110 | 80
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