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
- 21574 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sivakrishna
select * from emp as p where rowid<(select max(rowid) from
emp s where p.deptno=s.deptno);
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
whom do you report?
What are the features of datastage flow designer?
Which warehouse using in your datawarehouse
What is the difference between hashfile and sequential file?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Can you explain repository tables in datastage?
Name the different sorting methods in datastage.
What are the different options associated with dsjob command?
Nls stands for what in datastage?
How to reverse the string using unix?
what is flow of project?
What is a merge in datastage?
What is the use of datastage designer?
What are datastage sequences?
What is size of a transaction and an array means in a datastage?
