siripala

 Profile Answers by siripala 

• Jun 10th, 2008

 

select column_with_duplicates, count(*) from table_name group by column_with_duplicates;

will give you distinct column values against number of ocurances

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 20th, 2008

 

select * from  tale_name a  where rowid >any(select rowid from table_name b where a.col1=b.col1)
this query show duplicate record ina table and use delete command to eleminate duplicate record in the table.

hope this helpful to you

Ashish Sharma

suresh.kurapati11

 Profile Answers by suresh.kurapati11 

• Jul 13th, 2008

 

Use below query
select unique * from table_name;

vlaroyia

 Profile Answers by vlaroyia 

• Sep 22nd, 2008

 

One,

delete
from xyz a
where rowid >=
(select min(rowid)
from xyz b
where a.e_id = b.e_id)


Two,

delete from
   xyz
where rowid in
 (select rowid from
   (SELECT
     ROWID,
     ROW_NUMBER()
    OVER
     (PARTITION BY E_ID ORDER BY E_ID) dup
    from xyz)
  where dup > 1);

Three,

If there are NULLS,

DELETE FROM
   table_name A
WHERE
   A.rowid >
   ANY (SELECT B.rowid
   FROM
      table_name B
   WHERE
      A.col1 = B.col1
   AND
      A.col2 = B.col2
   )

rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Sep 25th, 2008

 

Assume  'location' is the column in 'Emp' table has several duplicates

EMP

Emp_Id   varchar(10)
Location  varchar(12)


 you can remove the duplicates using 'union' 

 select location from emp  union select location from emp ;

 this will strip the duplicates . 

  Hope this will help . 



 

kantri

 Profile Answers by kantri Questions by kantri

• Dec 5th, 2008

 

SELECT UNIQUE deptno FROM emp;
It will give you distinct deptno.

ravishengg

 Profile Answers by ravishengg 

• Oct 26th, 2009

 

Table Name: Tbl
Columns:A B C

DELETE FROM Tbl  where rowid not in (select A,B,C,Max(rowid) from Tbl Group by A,B,C)

anjinunna

 Profile Answers by anjinunna Questions by anjinunna

• Oct 29th, 2009

 

By using rowid we can elminate the duplicate records in a table

DELETE FROM TABLE_NAME WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM TABLE_NAME GROUP BY COLUMN_NAME);

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 19th, 2010

 

delete from tablename where rowin not in (select max(rowid) from tablename group by dup_col_name)

b.ganeshna

 Profile Answers by b.ganeshna 

• Jan 30th, 2010

 

Not only DISTINCT command and we can also use UNIQUE keyword.

debjit20

 Profile Answers by debjit20 

• Apr 9th, 2010

 

Method 1:
SELECT col1, col2, col3 ….. --(list all the columns for which you want to eliminate duplicates)
 FROM (SELECT col1, col2, col3,….. --(list all the columns as above), COUNT(*)
          FROM table)

Method 2:
SELECT col1, col2, col3 ….. --(list all the columns for which you want to eliminate duplicates)
FROM table
UNION
SELECT col1, col2, col3 ….. --(list all the columns for which you want to eliminate duplicates)
FROM table (use the same table).

This union will remove the duplicates.

kethinenisarath

 Profile Answers by kethinenisarath 

• Mar 15th, 2011

 

SELECT * from emp
where sal in (select sal from emp
Group by sal
having count(1)>1)

Thanks
ketarathhinenis

charchitsomani

 Profile Answers by charchitsomani 

• Mar 17th, 2011

 

By using JOIN command

Nikhil I

• Oct 12th, 2011

 

Suppose assume your table has 3 columns eno,ename,sal.

Code
DELETE FROM emp WHERE rowid IN(SELECT eno,ename,sal,max(rowid) FROM emp GROUP BY eno,ename,sal);

The above query will eliminates the duplicate records from the table.

Code
DELETE FROM emp WHERE rowid IN(SELECT eno,ename,sal,max(rowid) FROM emp GROUP BY eno,ename,sal);


 

BHAGABAT

• Apr 16th, 2016

 

SELECT COLUMN_NAME FORM TABLE_NAME GROUP BY COLUMN_NAME

sovenga_ngoveni

• Feb 23rd, 2017

 

You can use the GROUP BY keyword at the end of your query

Palak

• Apr 20th, 2017

 

By using Unique Command

Maria

• May 16th, 2017

 

With GROUP BY statement.