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

When we should use and scope of @@identity?

0 Answers  

What is merge replication?

0 Answers  

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  




How many types of schemas are there?

0 Answers  

In which year relase the 7.0& 2000 & 2005?

1 Answers  

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

What is history table in sql server?

0 Answers  

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

What is @@error in sql?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories