siva


{ City } guntur
< Country > india
* Profession *
User No # 75213
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 2
Questions / { siva }
Questions Answers Category Views Company eMail




Answers / { siva }

Question { Cap Gemini, 17878 }

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

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