Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11688 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
How to enter date and time literals in ms sql server?
Why do we backup Active Directory ?
What is correlated subquery in sql server?
What are the properties and different types of sub-queries?
Can we shrink data file in sql server?
How to get the number of affected rows?
What is raid? : SQL Server Architecture
What is snapshot replication?
Can you explain different types of locks in sql server?
Do you know what is normalization of database? What are its benefits?
What is identity?
What are the drawbacks of reporting in ssrs?
What is simple indexing method?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What do you mean by normalisation?
