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;

Which table is left in join?

0 Answers  

Does truncate table reset auto increment?

0 Answers  

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

What is difference between stored function and application function?

0 Answers  

What is rank () in sql?

0 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

what is difference between delete and truncate commands? : Sql dba

0 Answers  

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

select top 3 sal from each dept?

17 Answers   IBM, TCS,

What is varchar sql?

0 Answers  

what are the different types of joins?

4 Answers   Choice Solutions,

What are aggregate functions in sql?

0 Answers