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

Which tcp/ip port does sql server run?

0 Answers  

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

How do I run a pl sql procedure in sql developer?

0 Answers  

What is data abstraction in sql?

0 Answers  

How much does sql cost?

0 Answers  

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

select top 3 sal from each dept?

17 Answers   IBM, TCS,

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

List the ways to get the count of records in a table?

0 Answers  

What is procedure function?

0 Answers