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
- 21275 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sivaprakasam
select * from table1 where id in (select id from table1
group by id having COUNT(id) > 1)
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
How can you write parallel routines in datastage PX?
How to clean the datastage repository?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is meta stage?
What are the differences between datastage and informatica?
What is the purpose of pivot stage and types of containers in datastage
Can you explain repository tables in datastage?
Define orabulk and bcp stages?
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
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Differentiate between data file and descriptor file?
Differentiate between validated and Compiled in the Datastage?
What are the different common services in datastage?
On which interface you will be working as a developer?
