Sachin

• Aug 3rd, 2006

 

select * from emp

group by (empid)

having count(empid)>1

yakhubpasha

• Aug 12th, 2006

 

empid	empname	empsal
1	yakhub	20000
1	yakhub	20000
2	pasha	10000

    if the table is like this

         

         Delete from emp where

         Rowid not in (select min(rowid) from emp

        Groupby (empid,empname,empsal));

susindharan

 Profile 

• Aug 24th, 2006

 

select distinct empid,empname,empsal from emp;

csr21

 Profile Answers by csr21 Questions by csr21

• Sep 8th, 2006

 

select * from emp where empid in
(select empid from emp
group by empid having count(*)>1);

Sudeep Biswas

• Nov 8th, 2006

 

One more way to find out dupl. rows in a table (t_empolyee in this case) is:

-------------------------------

select emp_id, desg
 from t_employee t1
 where
( select count(*)
 from employee t2
where t2.emp_id = t1.emp_id) > 1

---------------------------------

Vijay Akumalla

• Dec 13th, 2006

 

Dear All, Let us use this space to answer questions correctly, instead of guess work. This website should be used to gain knowledge in the correct direction.

Nandu

• Feb 22nd, 2007

 

select * from tablename t1 where 1<(select * from tablename t2 where t1.col1=t2.col1);

mayank1710

 Profile Answers by mayank1710 

• Mar 26th, 2009

 

select * from acctcycle where acct_nbr in (select acct_nbr from acctcycle group by acct_nbr having count(acct_nbr)>1);

ashwani7jul

 Profile Answers by ashwani7jul 

• Jan 20th, 2010

 

DELETE FROM test

USING test, test AS vtable

WHERE (test.ID > vtable.ID)

AND (test.name=vtable.name)

Deleted duplicate records  query