Answer / lakshmi narayana

select * from emp a ,
(select empno,count(*) from emp group by empno having count
(*) > 1) b
where a.empno = b.empno

Answer / kalaiselvan.j

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

Answer / smita

select a.empno, a.empname from education a,
(select empno, count(*) cnt from education group by empno
having count(*) > 1) b
where a.empno = b.empno

is the correct answer

Answer / cesar di sanctis

select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)

Answer / lakshmi

In the above query we have to add distinct before *. Else
duplicate rows will be fetched twice.

Thanks,
Lakshmi

Answer / seshu

SELECT RNO,NAME,COUNT(*) REP_COL FROM Education GROUP BY
RNO,NAME having Count(*)>1;

Answer / amit

select * from taruntest1 b where rowid not in (select min
(rowid) from taruntest1 a where a.a=b.a );

Answer / balaji

For Sample:
----------

select count(pmid) as Occurances,pmid from tablename group
by pmid having count(pmid)>1

Answer / rajesh kumar patnaik

SELECT ProductName
FROM Products
WHERE (ProductName IN
(SELECT ProductName
FROM Products
GROUP BY ProductName
HAVING COUNT(*) > 1))

Answer / aravind

select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;

difference between cursor and procedure in a package

3 Answers   PCS,

why we use nocopy?

2 Answers   Polaris,

Can we use distinct and group by together?

0 Answers  

What is the sql*loader? : aql loader

0 Answers  

how is exception handling handled in mysql? : Sql dba

0 Answers  

How do you write a complex sql query?

0 Answers  

Explain the uses of a database trigger?

0 Answers  

Explain 3 basic parts of a trigger.

0 Answers  

Why procedure is used in sql?

0 Answers  

What is difference between nchar and nvarchar?

0 Answers  

what are the authentication modes in sql server? : Sql dba

0 Answers  

Is primary key an index?

0 Answers