沒有id, 去除笛卡爾積也會出現重復的現象, 如果圖上周杰倫出現一科80分一下, 也會查出來 , sql陳述句該怎么寫
uj5u.com熱心網友回復：
select name
from student
where fenshu>'80'
group by name
having count(1)=2
uj5u.com熱心網友回復：
select distinct s1.name from student s1 where s1.name not in (select s2.name from student s2 where s2.fenshu<80)uj5u.com熱心網友回復：
覺得樓上的對，還有就是你是不是看不起我馬哥？
uj5u.com熱心網友回復：
select distinct s1.name from student s1 where s1.name not in (s2.name from student s2 where s2.分數<=80);
uj5u.com熱心網友回復：
select b.name from ( select s.name name,min(fenshu) fenshu from studetn sgroup by s.name) b where b.fenshu>80
uj5u.com熱心網友回復：
-- 試試這個
select name
from t
group by name
having count(*) = sum(case when fenshu > 80 then 1 else 0 end)
uj5u.com熱心網友回復：
select name,min(fenshu)
from table
group by name having min(fenshu)>80
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/69654.html
標籤：開發
上一篇：oracle 查詢陳述句咨詢