Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Counting several items..


Message #1 by Aruna Koya <aruna.koya@d...> on Fri, 29 Jun 2001 15:01:30 +0100
I would like to select count (orderstatus) when new, ready, done,
processing where company = 'x' 
Important part  is I must get the no of new orders , no of ready orders
and no. of done orders and no. of processing orders.

How in one query ?  help 

thanks in advance
RnR

  Return to Index