1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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


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

Why use update_statistics command in sql server?

0 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

Which TCP/IP port does SQL Server run on?

2 Answers  

How many clustered indexes there can be on table ?

0 Answers  




How to add more data to the testing table in ms sql server?

0 Answers  

How to find the service pack installed? : sql server database administration

0 Answers  

What are the essential components of sql server service broker?

0 Answers  

What is view in sql?

0 Answers  

Differentiate between a primary key and a unique key.

0 Answers  

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories