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

How to update a field in SQL after ALTERING a row?

1286

Write a program to fetch first 10 records from a file?

1062

What is filestream?

1049

What does COMMIT command do?

1122

What is the difference between Normalization and De-normalization?

1144

What are the properties and different types of sub-queries?

1050

Can we add a cpu to sql server?

1061

Can I save my report as html, excel or word? : sql server management studio

1011

What are sub reports and how to create them?

144

What are the restraints imposed on the table design by a merge replication?

1088

What are the types of table?

1029

Does view occupy space?

991

What is the difference between upgrade and migration in sql server?

1150

How to enter date and time literals in ms sql server?

1066

Explain an incremental backup?

1050