how to count column Values in sql server

Question

hello friends : please suggest how to count column value in sql server

 

i.e i have one column name

products_id

and in this have two

 

values like 12,34

 

so i want to when select query execute than it show

product_id as producttotal= 2