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

5 Answers
13360 Views
Honeywell, Interact, I also Faced
E-Mail Answers

Answer Posted / ajit

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use sql statements in pl/sql?

1050

What is nosql db?

923

what is “go” in t-sql? : Transact sql

1038

What do you mean by stored procedures?

950

What type of database is cloud sql?

1041

what are the difference between clustered and a non-clustered index? : Sql dba

976

What is sql table?

902

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944

how to create a table index in mysql? : Sql dba

984

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1039

Explain the update statement in sql

915

What is a column in a table?

1060

What is type and rowtype in pl sql?

962

what is the command line end user interface - mysql? : Sql dba

925

What is sql clause?

992