What i want is count of similar datas in columns ie i my sample data A is twice so i want column heading as A and data as 2 similarly...

What i want is count of A,B and C in columns

ie Result should be like this

A B C

1 ...

What i want is count of A,B and C in columns

ie Result should be like this

A B C

1 ...

No always 4 Gno's its about 27 always both gno and bno r 27

Hello

I think it is better to open the connection and close only at the end of the application rather than opening connection and closing and again opening

anand

Thanks u all for solving my problem