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
- 13570 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
Is microsoft sql free?
How do I access sql anywhere database?
How many types of cursors supported in pl/sql?
List the different type of joins?
How many unique keys can a table have?
Explain ddl statements in pl/sql?
What does over partition by mean in sql?
Are subqueries faster than joins?
What is pl sql collection?
Could you please provide oca (oracle 10g) dumps for my certification ?
what is cross join? : Sql dba
When is a declare statement required?
What is set transaction?
How many sql databases can you have on one server?
What is sql profiler in oracle?
