How to do select in such query

[snooper1]

I have query ....
select account_no from test where element_id > 4618 and element_id < 4627

this gives me account_no which are not reapeted and reapeted
but i want only that which is repeated (not distinct)

thanks

 

[saikrish]

Hi,


Try this sql.

select account_no
from test
where element_id > 4618 and element_id < 4627
group by account_no
having count(*) > 1

All the best
Vijay