Imtiyaz Ansari

Imtiyaz Ansari

  • 591
  • 1.9k
  • 197.6k

Sql Query for featch data in sql 2008 R2

Jun 20 2014 2:38 AM
hi every one  
 
 
i am face a problem how to select data in single column  in two different column 
example
 
 [Field Name]
Amount
300
200
-5000
4250
-600 
 
required result :- 
amount1      amount 2 
 300              -5000
200               -600
4250 
 
 
Thank You ....... 
 

Answers (2)