Interested to Buy Any Domain ? << Click Here >> for more details...
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d f f
g h
- 1 Answers
- 4159 Views
- I also Faced
- E-Mail Answers
Answer Posted / anjana
Table test have one column as name:
Test
name
a
b
c
d
e
f
g
select replace(name,'e','f') from test order by name
Output will be:
a
b
c
d
f
f
g
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Do you know the isolation level that sql server support?
What is inline table-value user-defined function?
How real and float literal values are rounded?
Define magic tables in sql server?
Explain concepts of analysis services?
How ssrs maintain security?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Are null values the same as that of zero or a blank space?
What is raiseerror? What is raiseerror?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is mapping schema?
What is user-defined function?
