Tech Recorder
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment