普通青年、文艺青年、二逼青年写的SQL - 置顶：超级八卦 - 老八婆的八卦堡

[置顶：超级八卦] 普通青年、文艺青年、二逼青年写的SQL

xiaotao.2010 2011-11-17

普通青年写的SQL

select a.name,count(*) from t_data_dict a，t_client b
where a.id=b.client_level
and a.category='A'
group by a.name;

文艺青年写的SQL

select a.name,count(*) from（
select a.name,a.category
from t_data_dict a，t_client b
where a.id=b.client_level ) a
where a.category='A'
group by a.name;

二逼青年写的SQL

select a.name,count(*) from t_data_dict a join t_client b on a.id=b.client_level
where a.category='A'
group by a.name;

xiaotao.2010 2011-11-17