Re: [问题] SQL count 的替代方法

楼主: cspy (Perfect Stranger)   2010-10-20 11:36:50
select
*
from
(select *,count(name) as number from tt group by name) as x
where
x.age > 20 and x.number = 2 and car_id <> '';
※ 引述《dayyoung (dayyoung)》之铭言:
: NAME AGE CAR_ID
:
作者: zainan (宅男)   0000-00-00 00:00:00

Links booklink

Contact Us: admin [ a t ] ucptt.com