Select case when 1 then 'A' when 2 then 'B' when 3 th

there is a table having two columns no and name
and the data is
1 A
2 B
3 C

write a query that will result a horizontal output
A,B,C

Question Posted / b

Answer Posted / b

Select case when 1 then 'A'
when 2 then 'B'
when 3 then 'C' end as Name from tablename

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can you please explain the difference between primary keys and foreign keys?

1099

How to connect a database with sql express.?

1054

What are the properties of primary key?

965

Different types of keys in SQL?

1090

How do we synchronize On-Premise SQL server with SQL Azure?

122

List the different types of joins?

974

What is the purpose of sql profiler in sql server? : sql server database administration

1097

What is query parameter in ssrs?

160

What is store procedure?

1051

Explain about unique identifier data type in sql server?

905

What do you understand by user-defined function in the sql server?

945

How many servers can we create in a single subscription?

160

What is a unique key constraint?

1022

can an order by clause be used in a creation of a view?

1167

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

974