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?
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
How many areas for files does datastage have?
what is use of SDR function?
What is the difference between account and directory options ?
What is a ds designer?
why do u need the IOS upgradation in a FC switch
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What can we do with datastage director?
Is the value of staging variable stored temporarily or permanently?
what is the use of materialized view?
What is orabulk stage?
whom do you report?
What is ibm datastage?
Have you used Unstructured data?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are routines in datastage?