Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> A newbie query
I have a table t1(name, value).
The entries are (a1, 40), (a2, 233), (a3, 22).
Is it possible to write a query which tells me whether the value is above/below 100.
The output should be :
Name Value Comparison
a1 40 Below a2 233 Above a3 22 Below
Thanks in advance. Received on Thu Aug 02 2007 - 15:33:09 CDT