How to get column name in select query based on column value in sql server

Question

Table1:-

ID  NAME    ADDRESS
1   TEST1    qwr
2   TEST2    sdf

I wanted to get column name in the select query based on ID column value

EX:-

If the Id=1 i want "name" column in select query if id=2 i want "address" column in select query

select name from table (when id=1)
select address from table(when id=2)

I hope i conveyed my query clearly.

mendosi · Accepted Answer · 2017-10-12 11:17:18Z

2

This query will return the results in a single column and multiple rows:

SELECT CASE WHEN id = 1 THEN name WHEN id = 2 THEN address END AS result 
  FROM table;

answered Oct 12, 2017 at 11:17

mendosi

2,0611 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2017-10-12 11:13:14Z

0

You can use subqueries to get the two results:

select (select name from table where id = 1) as name,
       (select address from table where id = 2) as address;

answered Oct 12, 2017 at 11:13

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges