Hi friends, I got a solutions. Thanks.

Hi friends, I have a table like below, account_no linked_acc_no --------- ------------- aaa bbb bbb ccc bbb ddd eee ccc ddd fff fff ggg eee hhh hhh iii xxx zzz xxx yyy vvv www I need a query to select account no which are linked with 'aaa'. So the o/p should be like this, o/p --- bbb ccc ddd eee fff ggg hhh iii any one can help me on this?..