CareerCup

<pre lang="java" line="1" title="CodeMonkey47229" class="run-this">create table temp(id int primary key, value nvarchar(256))

insert into temp values(1,'a')
insert into temp values(2,'b')
insert into temp values(3,'b')
insert into temp values(4,'c')


select distinct t1.value
from temp t1,temp t2
where t1.value = t2.value
and t1.id <> t2.id

--OR

select count(*),t.value
from temp t
group by t.value
having count(*) > 1</pre><pre title="CodeMonkey47229" input="yes">
</pre>

a primary key cannot be double it has unique values ?????/

I think the interviewer is curious about the GROUP BY in Database.

Question is not clear. How were duplicate rows inserted into the table when it has a primary key?

assuming primary key is logical and no PK constraint created

select * from order a where rowid in
(select min(rowid) from order b where a.orderid=b.orderid)

select t1.id, t2.id, t1.name
from orderT t1, orderT t2
where t1.name=t2.name and t1.id>t2.id

hi