TA貢獻(xiàn)1877條經(jīng)驗(yàn) 獲得超1個(gè)贊
select distinct 姓名 from 表 where 姓名 in (select 姓名 from 表 where 成績(jī)>80 having count(*) =(select count(distinct 科目) from 表))
TA貢獻(xiàn)1797條經(jīng)驗(yàn) 獲得超4個(gè)贊
SELECT * FROM `name` WHERE `banji` like '%三年二班%'and ‘id’ between 200 and 300
舉報(bào)
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購(gòu)課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)