Sql Query

[ram007]

There is a table which is not having any Constraints.
I want to display a column with some values (not all).
In that column I want to display only some values which are occurring more then one time.
Ex
Let us consider emp table in emp table emp no 7433 is occurring more then one time then I want to display only 7433.
Please help me
Thanks&Regards
Sarma

[ram007]

i got the query

select emp_no,count(emp_no) from emp
group by emp_no
having count(emp_no) > 1

[ram007]

select emp_no,count(emp_no) from emp
group by emp_no
having count(emp_no) > 1
Regards
Sarma

[zahid_ali]

select count(emp_no) "Emp_NO" from emp
group by emp_no
having count(emp_no) > 1

does that solve your problem???

[oraclejo]

how about

SELECT DISTICT empno, ....

Ammar Sajdi
www.e-ammar.com

[tonyhoward88]

is there a particular way to save 'text' field types? i get this error: You have an error in your SQL syntax near 'desc = test' at line 1