Table Column values

Hi.

please follow nitin comments but for each group you need to hit db each time and retrieve the data, use it.

thanks. 

The term "group" used by you is not quite clearly understood by me. I will assume that you mean to say in one go or in one result set. Clarify if my understanding is wrong.

 

You can use following script. Please modify table name, column name as appropriate.

 

select *

from tblEmployee

 

Hope it helps!