i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?
Answer Posted / vamsi
HI,
ANY ONE TELL ME HO WE CAN DONE THIS IN DATASTAGE?
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the different type of jobs in datastage?
Define oconv () and iconv () functions in datastage?
Differentiate between data file and descriptor file?
What is size of a transaction and an array means in a datastage?
What are the processing stages?
Name the command line functions to import and export the DS jobs?
What is the difference between Datastage 7.5 and 7.0?
What are the types of jobs we have in datastage?
What a datastage macro?
Name the different sorting methods in datastage.
Can you explain link buffering?
Which algorithm you used for your hashfile?
Is possible to create skid in dim,fact tables?
Enlist various types of routines in datastage.
What is ibm datastage flow designer?