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
- 9 Answers
- 10744 Views
- tdfc, vsworx, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Is sql server free?
What do you mean by acid?
How would you go about developing a ssrs report?
How to create a stored procedure with a statement block in ms sql server?
What are binary string data types in ms sql server?
How to convert character strings into numeric values?
Explain the commands in sql server?
How many categories of data types used by sql server?
Can sql servers linked to other servers like oracle?
In which sql server version report builder introduced?
What are various ways to enhance the ssrs report?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What will be the maximum number of indexes per table?
How except clause is differs from not in clause?
What is the difference between getdate and sysdatetime?
