1、单行子查询
2、多行子查询
3、多列子查询
where (job,sal) = (select job,sal from emp where empno=123)
4、关联子查询
5、结果集分页查询
2、多行子查询
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522764010hX43.png?x-oss-process=style/bb)
3、多列子查询
where (job,sal) = (select job,sal from emp where empno=123)
4、关联子查询
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522764512OzZL.png?x-oss-process=style/bb)
5、结果集分页查询
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522764566QmQq.png?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31476473/viewspace-2152581/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31476473/viewspace-2152581/