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
- 4084 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
Differentiate between truncate vs delete in mssql?
Explain the phases a transaction has to undergo?
Explain features of analysis services?
Define full outer join?
What is partition in sql server?
Can another user execute your local temporary stored procedures?
What is coalesce in sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
Explain what is lock escalation?
Do you know what is a trace frag? Where do we use it?
What is difference between standardization and normalization?
Do you know the capabilities of cursors?
What command must you use to include the not null constraint after a table has already been created?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are trace flags and mention a few common trace flags used with sql server?
