I have a table as Student(st_id,st_name,st_number). In this table it is possible that each student can have multiple records. Now I want to display only those records which are distinct by st_name in CGridview.
Sample Data can be :
Sample Query can be :
"select distinct(st_name) from student;"
How to set distinct value only on "st_name" column?