Yii 1, how to display only one value from the base in TbGridView?

Question

MySQL

There is a table with the structure
id,
room_id, (class id)
name (item name)
it is necessary that only one item for all classes be displayed (i.e., in the database there is a record of the form: geography - 1st class, geography - 2nd class) , the output is just a subject for all classes))

Answer 1

SELECT "география" FROM название_таблицы