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
- 5 Answers
- 12089 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
What is varchar data type in sql?
What is the usage of nvl function?
How can we find duplicate records in a table?
What are the limitations of sql express?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
what are the differences between require and include, include_once and require_once? : Sql dba
What is an inconsistent dependency?
How we can update the view?
Why use subqueries instead of joins?
What is clause in sql?
Are subqueries better than joins?
What is the purpose of the primary key?
What is difference between my sql and sql?
Where not exists in sql?
What is sp_helptext?
