SQL Query
597023Sep 12 2007 — edited Sep 12 2007Hi,
I have a table with a single column of number type.
and the data is as follows
col1
----------
12
22
33
-4
-6
-4
Now i need a query which gives the output as follows
(Two columns positive and negative)
positive negative
---------- ------------
12 -4
22 -6
33 -4