2009/11/05

two select

Two selects:

SELECT cart_name as tag, count(cart_name) as frequency
From
  (SELECT distinct cart_name , account_id
   FROM `account_cart`
   where cart_name REGEXP '^[a-z]+'
) as tb1
Group by cart_name



No comments:

Post a Comment