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
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
What is the template in sql?
What are the events recorded in a transaction log?
Explain different types of locks in sql server.
Does view occupy space?
Can you explain various data region available in ssrs with their use?
What is a synonym for manipulation?
Why should you use or avoid select * statements?
How to get the definition of a view out of the sql server?
How to use wildcard characters in like operations in ms sql server?
How to create function with parameter in sql server?
What is the exact numeric data type in sql?
What is the difference between cartesian product and cross join?
Why use view instead of a table?
What is the difference between locking and multi-versioning?
Can you explain full-text query in sql server?