Aug 7, 2003 #1 snooper1 Programmer Joined Aug 7, 2003 Messages 1 Location NZ 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
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
Aug 7, 2003 #2 saikrish Programmer Joined Jul 31, 2002 Messages 16 Location IN 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 Upvote 0 Downvote
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