Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13757 Views
- Honeywell, Interact, I also Faced
- E-Mail Answers
Answer Posted / pankaj goyal
SQL wm_concat function
Question: I have a table test_test and I need to count the
distinct mark columns and them display all matching values
on one line:
Name Mark
------- ------
ABC 10
DEF 10
GHI 10
JKL 20
MNO 20
PQR 30
The result should be like this, with the count and the rows
groups onto the same line;
mark count names
---- ----- -----------
10 3 ABC,DEF,GHI
20 2 JKL,MNO
30 1 PQR
Answer: By Laurent Schneider: You could write your own
aggregate function or use WM_CONCAT:
select
mark,
count(*),
wm_concat(name)
from
test_test
group by
mark;
Here is another example of using wm_contcat:
select
deptno,
wm_concat(distinct ename)
from
emp
group by
deptno;
DEPTNO WM_CONCAT(DISTINCTENAME)
---------- ----------------------------------------
10 CLARK,KING,MILLER
20 ADAMS,FORD,JONES,SCOTT,SMITH
30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What does an inner join do?
What is the sql case statement?
What is a file delimiter?
What is the default isolation level in sql server? : Transact sql
Why are indexes and views important to an organization?
Does pl/sql support create command?
What is the meaning of disabling a trigger?
how can we repair a mysql table? : Sql dba
What is the command used to fetch the first 5 characters of a string?
What is trigger in pl sql?
Where can I learn sql for free?
What is the difference between syntax error and runtime error?
What is sql key?
How do I start sql profiler?
What is the limitation on the block size of pl/sql?
