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

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

What is ddl and dml commands?

0 Answers  

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

What is the process of indexing?

0 Answers  

What is truncate table?

0 Answers  

What is sub query and its properties?

0 Answers  

What is usually the first word in a sql query?

0 Answers  

What is resource db in sql server?

0 Answers  

How does recursive cte works in sql server?

0 Answers  

What will be query used to get the list of triggers in a database?

0 Answers  

Explain the properties of a relational table?

0 Answers  

How do you drop an index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories