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
- 11613 Views
- Honeywell, Interact, I also Faced
- E-Mail Answers
Answer Posted / ramaraju
select listagg(cust,' ') within group(order by cust) from t2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are different types of keys in sql?
Does truncate release storage space?
what is single byte over head in oracle..?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Is sql difficult?
What is difference between sql function and stored procedure?
Which command is used to delete a package?
How do I run a program in pl sql?
What is a schema sql?
what is a constraint? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are sql commands?
What is the current version of sql?
Why do we use joins?
What is java sql package?
