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
- 4168 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
query processing
Give an example of why you would want to denormalize a database
How to count rows with the count(*) function in ms sql server?
What is named calculation? : sql server analysis services, ssas
What is bit data type? What's the information that can be stored inside a bit column?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is the difference between Triggers and Stored Procedure?
How to recover from sql injection? : sql server security
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is database mirroring?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Does partitioning improve performance?
What happens if we shrink log file in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
