Answer / priya

select coloumn_name ,count(*) from table_name
group by coloumn_name
having count(*) > 1;

Answer / babu

Try this,
select col1,count(col1) from tab1
group by col1 having count(col1)>1;

If you want to delete these duplicate entries, use:
delete from tab1 where col1 in (select a.col1 from
(select col1,count(col1) from tab1
group by col1 having count(col1)>1) a);

Answer / purushotham

select column,count(1) from a
group by column
having count(1)>1;

Answer / dev

Hi,
There are many ways to do it.

One of that is ,

select count(0) from tab1 a
where a.rowid > any (select b.rowid from tab1 b where
a.col1 =b.col1);

Answer / akki julak

select count(empno)-count(distinct(empno)) from emp;

Answer / ajmal khan

There are many way to count the duplicate row in a table
select count(column_name)-count(distinct(column_name)) from
table_name;

Answer / suresh a

select sum(count(col1) -1) from emp
group by col1 having count(col1) > 1

Answer / shalu

select count(*) from table_name group by column1,column2...
having count(*) > 1

Answer / sravan

Hi here is another way to solve this

SELECT NAME, COUNT(NAME) FROM TABLE_NAME
WHERE NAME IN (SELECT NAME FROM TABLE_NAME
GROUP BY NAME
HAVING COUNT(NAME)>1)
GROUP BY NAME;

thanks

Answer / satheesh

SELECT COUNT(*)
FROM TABLE A
WHERE ROWID NOT IN (SELECT MAX(ROWID)
FROM TABLE B
WHERE A.COL1 = B.COL1);--UNIQUE COLUMN

Does db2 use sql?

0 Answers  

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

Which is the best place to learn hadoop?

1 Answers  

What is dml and ddl?

0 Answers  

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

can we update a view which is created from two tables

11 Answers  

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

What is character functions?

0 Answers  

What is trigger in sql? Explain

0 Answers  

Explain ttitle and btitle.

0 Answers