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
- 4224 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to concatenate two binary strings together?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How do I view views in sql server?
What is subreport?
What is checkpoint process in the sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What does it mean to invest in the index?
Do you know hot add cpu in sql server 2008?
What is a print index?
What are the types of table?
do views contain data ?
What is the exact numeric data type in sql?
How to change the ownership of a schema in ms sql server?
What is a collation in ms sql server?
