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
Terminate Activity
What is the precedence of stage variables,derivations, and constraints?
What is apt_config in datastage?
Differentiate between Join, Merge and Lookup stage?
What is the flow of loading data into fact & dimensional tables?
root tree will find which is server job and which is parallel job?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are constraints and derivations?
What is a merge in datastage?
What is the difference between Datastage 7.5 and 7.0?
Highlight the main features of datastage?
Define repository tables in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Explain usage analysis in datastage?
What is orabulk stage?