subqueries

          1 Guidelines for Using Subqueries
          ?a Enclose subqueries in parenttheses
          ?b placce subqueries on the right side of the comparision condition
          ?c the order by clause in the subquery is not needed
          ?d using single-row operators with single-row subqueries and use multiple -row operator with multiple-row subqueries .
          ? single-row subqueries can work as a expression,and muitiple-row subqueries can only be used with in all any ,i will talk it later
          ? select last_name where job_idd=(select job_id
          ????????????????????????????????? from employees
          ????????????????????????????????? where imployee_id=141)
          2 The HAVING CLause with Subqueries
          ?a The Oracle server execute subqueries first
          ?b The Oracle return result into the HAVING clause of the main query
          ? select department_id,min(salary)
          ? from employee
          ? group by department_id
          ? having min(salary)>
          ???????????????????? (select min(salary)
          ????????????????????? from employees
          ????????????????????? where department_id=50);
          3 Multiple-Row Subqueries
          ? a Return? more than one row
          ? Using mutiple-row comparsion operator
          ? select employee_id
          ? from employees
          ? where salary<any
          ????????????????? (select salary
          ?????????????????? from employees
          ?????????????????? where job_id='ddd')

          ? select employee_id
          ? from employees
          ? where salary<all
          ????????????????? (select salary
          ?????????????????? from employees
          ?????????????????? where job_id='ddd')
          ?? select emp.last_name
          ?? from employees emp
          ?? where emp.employee_id not in
          ?????????????????????????????? (select mgr.manager_id
          ??????????????????????????????? from employees mgr)

          posted on 2006-09-22 16:25 康文 閱讀(261) 評論(0)  編輯  收藏 所屬分類: 數據庫

          <2006年9月>
          272829303112
          3456789
          10111213141516
          17181920212223
          24252627282930
          1234567

          導航

          統計

          常用鏈接

          留言簿(1)

          隨筆分類

          隨筆檔案

          文章檔案

          搜索

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 瑞安市| 广西| 桐城市| 汾阳市| 密山市| 河津市| 曲松县| 枣阳市| 广河县| 秭归县| 三原县| 大石桥市| 灌阳县| 沁水县| 永修县| 班戈县| 阳曲县| 松溪县| 恩平市| 连南| 五家渠市| 定结县| 宜川县| 湖南省| 阳信县| 万荣县| 麟游县| 奉新县| 阿鲁科尔沁旗| 筠连县| 柘城县| 东城区| 仁怀市| 罗山县| 恭城| 高唐县| 清镇市| 大洼县| 古田县| 北海市| 富平县|