查詢除掉名字中含有K的員工后，員工人數大于3的各種作業，按作業降序排列，這個陳述句我自己寫的是select * from emp where ename <> '%K%'K from (select job , count(*) from emp group by job having count (*)>3);這是哪里出錯了？？？
uj5u.com熱心網友回復：
SQL語法不對首先ename <> '%K%' 寫的就不對，模糊查詢要用LIKE，應該改成ename not like '%K%'
其次兩個查詢條件之間要用and或者or,
你寫的ename <> '%K%'K from (select job , count(*) from emp group by job having count (*)>3)完全不對
應該是
where ename not like '%K%'
and job in (select job
from (select job , count(*) from emp group by job having count (*)>3))
再次沒有排序
完整的寫法
select * from emp
where ename not like '%K%'
and job in (select job
from (select job , count(*)
from emp
group by job
having count (*)>3))
order by job desc
建議好好打一下基礎
uj5u.com熱心網友回復：
注意“后”,應先剔除名字中含有K的員工uj5u.com熱心網友回復：
嗯，謝謝
已經看懂了
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/38299.html
標籤：基礎和管理