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;

What are views in sql?

0 Answers  

what is the difference between implicit conversions and explicit conversions?

2 Answers  

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

How many aggregate functions are available there in sql?

0 Answers  

How do you modify a column in sql?

0 Answers  

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

what is a database lock ? : Sql dba

0 Answers  

What is the current version of postgresql?

0 Answers  

how do you control the max size of a heap table? : Sql dba

0 Answers