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   Cap Gemini,

---

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

how will u design file watch jobs?

2 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

What are the main features of datastage?

0 Answers  

---

how to delete one row in target dataset

0 Answers   Satyam,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

---