求解決~
uj5u.com熱心網友回復：
select b.d,count(1)
from test1 a,(select distinct c,d from test2) b
where a.b=b.c
and a.d in (20160101,20160102)
group by b.d;
uj5u.com熱心網友回復：
select count(*) , xuehao(b),xingming(d),a.banji(a)
from test1 a,test2 b
where a.banji=b.banji
and a.xuehao=b.xuehao
and a.xuehao between 1100 and 1200
group by xuehao(b),xingming(d),a.banji(a)
uj5u.com熱心網友回復：
select b.d,count(1)from test1 a,(select c,d from test2) b
where a.b=b.c
and a.d in ('20160101','20160102')
group by b.d;
uj5u.com熱心網友回復：
表名寫在括號里，那個版本用法？
感覺有點詭異
uj5u.com熱心網友回復：
如果時間是date型別，你再轉換一下日期型別select t2.姓名（d）,count（*） from test1 t1,test2 t2 where t1.班級（a）=t2.班級(a) and t1.時間(d) between '20160101' and '20160102' group by t2.姓名（d）
uj5u.com熱心網友回復：
t2中第二條記錄的學號應該是1101吧？select t2.b 班級,t2.d 姓名,count(*) as 學科次數 from test2 t2 left join test1 t1 on t2.c=t1.b
where t1.d in (20160101,20160102);
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/109214.html
標籤：開發