TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Sujit Sahoo
NA
346
37.3k
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?
Reply
Answers (
8
)
Difference between Outer Join and Left Outer Join .
How to Check Database Status