Hi ramesh,

Thanks a lot.....

That query worked fine.....

It really helped me alot

You are using two joins in the same query......

But i want to avoid that.... as the table size is big....

Actually i need only teacher id/id's (but not the count) with minimum students assigned to them.