Sujit Sahoo

Sujit Sahoo

  • NA
  • 346
  • 37.7k

Display positive and negative values in different column

Mar 11 2019 10:39 AM
Here, I have one Table T1.
In that table, I have one column F1 having some positive and negative values.
I want to display those values in two different columns. 
 
select * from T1 
 
F1
--------
1000
-2000
500
-1000
2000
-300
 
I want to display like this 
 Pos           Neg 
-------          ------
 1000         -2000
 500           -1000
 2000         -300
 
How to do this any suggestion? 

Answers (8)