[SQL] How to get Rows Count

[Abdul Wahab Dahalan]

a       b      d    c  
01      02     b    *  
01      02     a    *  
02      03       
02      04     b    *  
02      04     a    *  
03      05  
04      06  

If I've a table like above, how do I make a query to get rows count that 
doesnt have '*' in it.

Can we have other queries than this : Select count(c) from tablename 
where c !='*';
or Select count(c) from tablename where c <> '*';



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])