bharani kumar wrote:
> My fields something like
> i know , i can display all hospital code with unique , but i dont in the
> single column , with unique record,
> Can you tell me how to do this ?
Would it be possible to reconsider your table design?
Instead of having the above, have something such as:
You'd then have something such as:
You'd then be able to find all of the distinct hospital codes by doing
select distinct code from hospital.
Apologies if this isn't possible.