One table Test with single column. These are the values in the table a b c

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

1 Answers
4085 Views
I also Faced
E-Mail Answers

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

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers

Explain some DBCC commands?

6 Answers

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers

Explain trigger and its types?

0 Answers

How to access the deleted record of an event?

0 Answers

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers TCS,

write the query for taking database backup in sql

10 Answers ABC, IBM, Logica CMG, MA,

When would you use sql joins?

0 Answers

How to add a new dsn with the odbc driver for sql server?

0 Answers

What is the difference between a view and a stored procedure?

0 Answers

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers TCS,

For more SQL Server Interview Questions Click Here