Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Can we call stored procedure in trigger?

0 Answers  

Do you know what are acid properties?

0 Answers  

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

What is sql server profiler?

0 Answers  

What are synonyms?

0 Answers  

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

If a stored procedure is taking a table data type, how it looks?

1 Answers  

What is sub-query in sql server? Explain its properties.

0 Answers  

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

For more SQL Server Interview Questions Click Here
Categories