add distinct in select

Yii 1.1 General Discussion
1

hi all

i am trying to query a select distinct . The code i wrote is




  $stud= Yii::app()->db->createCommand(array(

     			 'select Distinct' => 'stud_number',

 				   'from' => 'tbl_student',

				               ))->queryColumn();

please help me

2

Did you try to remove the space between select and Distinct? API reference (see also constructor documentation). Perhaps even ‘distinct’=>true has to be added?

/Tommy

3

Thank you tri

this is working





 $stud= Yii::app()->db->createCommand(array(

                         'select' => 'stud_number',

                           'distinct' => 'true',

                                   'from' => 'tbl_student',

                                               ))->queryColumn();