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
4088 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 do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers

Explain how does the report manager work in ssrs?

0 Answers

How column data types are determined in a view?

0 Answers

Is it possible to create trigger on views?

0 Answers

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers Amdocs,

How you can minimize the deadlock situation?

0 Answers

Explain the dirty pages?

0 Answers

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers

Explain boyce and codd normal form(bcnf)?

0 Answers

Explain partitioned view?

0 Answers

Can group by and orderby be used together?

0 Answers

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers

For more SQL Server Interview Questions Click Here