eno ename
1 qaz
1 wsx
1 edc
2 zxc
2 asd
3 qwe
3 wer
3 tru
4 rgj
Output:
eno ename count
1 qaz,wsx,edc 3
2 zxc,asd 2
3 qwe,wer,tru 3
4 rgj 1
I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
Answer Posted / ajajsp
select eno, ename, count(*) from Table_Name group by eno, ename
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
Define ds designer?
How we can covert server job to a parallel job?
Explain datastage architecture?
What is use Array size in datastage
What is difference between join, merge and lookup stage?
What are the types of containers in datastage?
How complex jobs are implemented in datstage to improve performance?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the types of jobs we have in datastage?
How do y read Sequential file from job control?
Define repository tables in datastage?
What is the difference between the local container and shared container?
explain about citrix scheduling tool in datastage
how to abort the job its matain duplicates?