select Replace ( Wm_concat( a ), ',' ) Actout from Tablename;

how can we write a column values horizontal by using sql stmt;
ex:
select name from table_name;(actual output)
a
b
c
d
require output is
a b c d

Question Posted / ajit

Answer Posted / ajit

select Replace ( Wm_concat( a ), ',' ) Actout
from Tablename;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how are mysql timestamps seen to a user? : Sql dba

1139

What does dml mean?

988

What is string join?

979

What is the example of procedure?

928

What are records give examples?

1009

What is a left inner join?

1015

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1002

How do I run sql profiler?

1072

How do you sort in sql?

1027

What is trigger in pl sql?

1002

What is the difference between a primary key and a clustered index?

993

What are the events on which a database trigger can be based?

1189

Can we insert in sql function?

1088

Explain the significance of the & and && operators in pl sql.

1009

What are analytic functions in sql?

1025