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
- 21583 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / prathapreddy
select col1,count(*) from <table name> group by col1 having
count(*)>1;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to read the length of word in unix?
Describe link sort?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the difference between orabulk and bcp stages?
How to convert RGB Value to Hexadecimal values in datastage?
What steps should be taken to improve Datastage jobs?
What are the difference types of stages?
What are the some differences between 7.x and 8.x version of datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is merge stage?
Differentiate between Join, Merge and Lookup stage?
what is the use of materialized view?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the different common services in datastage?
What is the purpose of pivot stage and types of containers in datastage
