One table Test with single column. These are the values in the table a b c

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

Question Posted / ayanb1302

1 Answers
4225 Views
I also Faced
E-Mail Answers

One table Test with single column. These are the values in the table a b c d e f g h I ne..

Answer / 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

More SQL Server Interview Questions

How to generate create view script on an existing view?

0 Answers

Which stored procedure will you be running to add a linked server?

1 Answers

How do I get to sql server configuration manager?

0 Answers

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers

When do you create cluster and noncluster index?

5 Answers Satyam,

Define left outer join?

0 Answers

How are SQL Server databases physically stored under Windows 2000?

1 Answers

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers Wipro,

What is the default port for SQL Server over a firewall?

0 Answers Microsoft,

How can you append an identity column to a temporary table?