Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4106 Views
- I also Faced
- E-Mail Answers
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 |
What is the use of sql profiler in sql server 2012?
What is difference between rownum and row_number?
What are the operating modes in which database mirroring runs?
How the data stores in a page?
Is it possible to create trigger on views?
what is the different types of backups available in sql server? : Sql server database administration
Explain the xml support sql server extends?
Can an entity have two primary keys?
what's the maximum size of a row? : Sql server database administration
What is a mixed extent?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to retrieve error messages using odbc_errormsg()?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
