查询除掉名字中含有K的员工后,员工人数大于3的各种工作,按工作降序排列,这个语句我自己写的是select * from emp where ename <> '%K%'K from (select job , count(*) from emp group by job having count (*)>3);这是哪里出错了???
解决方案 »
- packages中的想要单独编译某个具体存储过程该如何操作?求高手指点
- 还有一个sql语言郁闷了好久(mysql跟oracle区别这么大呢(╰_╯)
- 多主体复制:帮助中说可以用Replication Management API在不静默主题站点的情况下来实现增加主体站点,请问如何实现?
- 好消息,好消息,100分送一楼,马上给分了,
- ORACLE 执行作业出现的问题
- 高分求助shell命令
- oracle9i如何导出导入(imp/exp)作业(job)?
- alter Database SET TIME_ZONE = '+08:00' 报错?
- 请问ORACLE9I要用到多少硬盘空间呢
- 如何建立一个复杂的VIEW
- cx_oracle 求解 救救孩子吧
- 关联查询时,有数据的表以空表表现出来
其次两个查询条件之间要用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建议好好打一下基础