Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 20841 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
What is the purpose of pivot stage and types of containers in datastage
what is the use of surogate key in datastage
How many types of sorting methods are available in datastage?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
Explain connectivity between datastage with datasources?
What is size of a transaction and an array means in a datastage?
What are the components of datastage?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
project Steps,hits, Project level HArd things,Solved methods?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
what is combinability and non combinability?
Teradata 
