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 / varaprasadsams
Hi Dear,
The above query is 100% correct, i tried.
comming to datastage, source-sort stage-transformer-trg.
in sort stage create keychange column , in tfm choose constraint as zero...sure u wil get...
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Describe the main features of datastage?
What are the features of datastage flow designer?
How do u convert the columns to rows in datastage?
How do you generate sequence number in datastage?
how can we create rank using datastage?what is the meaning of rank?
Differentiate between odbc and drs stage?
What is the difference between the local container and shared container?
Define repository tables in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the project in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between operational data stage (ods) and data warehouse?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are iconv and oconv?