SQL Select Diferent Values In the Same Column

Question

0.00/5 (No votes)

See more:

Hello,

I wanted to know if it is possible to select 1 value from 2 diferent Columns in the same table and display them in the same column.

Heres an Example.

Total Free Space     |     Total Space
10                            30
20                            10
40                            20

Show something like:

10 --First Column
30 --Second Column

Thank You.
Best Regards.

Posted 24-May-12 1:08am

Member 8956437

Updated 24-May-12 10:38am

Wendelius

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-05-24T01:12:00

Solution 1

SQL

SELECT F1 
FROM Table1
UNION ALL
SELECT F2 AS F1 
FROM Table2

More at MSDN: UNION[^]

[EDIT]
Analogically, if data comes from the same table:

SQL

SELECT F1 
FROM Table1
UNION ALL
SELECT F2 AS F1 
FROM Table1

[/EDIT]

Posted 24-May-12 1:12am

Maciej Los

Updated 24-May-12 2:39am

v2

Comments

Member 8956437 24-May-12 7:20am

What if they are in the same table?

Maciej Los 24-May-12 8:37am

In the first post, you have wrote, that columns comes from different tables. So... an answer is as is.
Analogically... See my answer after changes.

VJ Reddy 24-May-12 8:49am

Good answer. 5!

Maciej Los 24-May-12 11:48am

Thank you, VJ ;)

Sandeep Mewara 25-May-12 1:54am

Good one. 5!

Maciej Los 25-May-12 4:07am

Thank you, Sandeep ;)

ujju.1 · Answer 2 · 2012-05-24T01:17:00

Solution 2

you can use union all for this
e.g.

SQL

select column_Name1 from tbl_1 union all select column_Name2 from tbl_2

Posted 24-May-12 1:17am

ujju.1

Updated 24-May-12 10:39am

v2

Comments

Member 8956437 24-May-12 7:20am

What if the Values are in the same table, but in diferent Columns

ujju.1 24-May-12 8:52am

even then, it will be similar to the first one. i.e.
select column_Name1 a from tbl_1 union all select column_Name2 a from tbl_1

Wendelius · Answer 3 · 2012-05-24T10:43:00

You haven't mentioned the exact logic you're trying to use since the answer may vary depending on the needs. But if you want for example pick a value from some column in your query then you can use CASE[^]

An example

SQL

SELECT CASE
          WHEN column1 = 10 THEN column1
          WHEN column2 = 30 THEN column2
          ELSE column3
       END AS ResultColumnName
FROM YourTable