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 many triggers are possible per table?

1073

What are the differences between DDL, DML and DCL in SQL?

1206

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1011

What do we need queues in sql service broker?

1051

What is difference between join and natural join?

943

What are the properties of the transaction?

992

How do you debug a procedure in sql server?

926

What are commonly used odbc functions in php?

1001

How will you optimize a stored procedure optimization?

1014

what's sql server? : Sql server database administration

979

Explain table valued parameters in sql server? Why tvp used?

1001

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1111

Explain an incremental backup?

978

What are the differences between sql server and mysql.

1071

What is 'write-ahead log' in sql server 2000 ?

1031