>Hi guys!
>
>I have a table with the next rows:
>
>field1 field2
>Site A Cell 101
>Site A Cell 101
>Site A Cell 102
>Site A Cell 102
>Site A Cell 103
>Site A Cell 104
>Site B Cell 201
>Site B Cell 201
>Site B Cell 205
>
>
>well, I am locking for sql statment that produces the next dataset result:
>Site Cells_Working
>Site A 4
>Site B 2
>
>I'am trying with :
>Select field1 as site,count(field2) as Cells_working from mytable group by; field1
>but it doesn´t work
>Thanks in advance

Try

Select field1 as site,count(<B>DISTINCT</B> field2) as Cells_working;
   from mytable ;
   group by field1

>martin Alcaraz
>malcaraz@rtn.uson.mx