select eno, ename, count(*) from Table

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.

Question Posted / ajajsp

4 Answers
8295 Views
Wipro, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What steps should be taken to improve Datastage jobs?

1075

What are stage variables and constants?

1149

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2237

What are the steps needed to create a simple basic datastage job?

1240

What is the purpose of pivot stage?

1171

How do you reject records in a transformer?

1125

what are the errors,warnings in datastage

2703

What are the different types of lookups in datastage?

1055

What is the difference between datastage and datastage tx?

1070

What are stage variables, derivations and constants?

1231

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

What are sequencers?

1122

how to export or import the jobs in .ISX file

1203

table actions available in oracle connector?

1613

Does datastage support slowly changing dimensions ?

1109