ORDER BY 的时候不能在select 句子中用sequence

最新推荐文章于 2023-06-05 17:04:37 发布

最新推荐文章于 2023-06-05 17:04:37 发布 · 461 阅读

文章标签：

#EXT #C #C++ #C#

PL/SQL 专栏收录该内容

3 篇文章

订阅专栏

本文提供了一个复杂的SQL查询示例，用于从多个表中选择特定条件的数据，并通过联接操作来确保数据的一致性和准确性。该查询展示了如何使用子查询、连接条件以及排除已存在的记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT seq_com_id.NEXTVAL delta_id,XX.* FROM (
   SELECT
    'EXT' delta_type, NULL paper_no,
            'D10041' err_cd, 'SYSTEM' created_by, SYSDATE created_dt,
            'SYSTEM' updated_by, SYSDATE updated_dt, NULL deleted_by,
            NULL deleted_dt, 1 VERSION, x.exam_yr, x.exam_lvl_cd,
            x.exam_series_cd, x.index_no, x.subj_cd
       FROM (SELECT DISTINCT a.exam_yr, a.exam_lvl_cd, a.exam_series_cd,
                             a.index_no, a.uin, a.reg_stat_nm, a.dob,
                             b.subj_cd
                        FROM xe_rp_cddt_reg a,
                             xe_cddt_posting_paper b,
                             xe_subj_configuration c
                       WHERE a.exam_yr = 2008
                         AND a.exam_lvl_cd = 'GCEA'
                         AND a.exam_series_cd = 'YE'
                         AND (a.reg_st = 'N' OR a.reg_st = 'R')
                         AND a.cddt_reg_id = b.cddt_reg_id
                         AND a.exam_yr = b.exam_yr
                         AND a.exam_lvl_cd = b.exam_lvl_cd
                         AND a.exam_series_cd = b.exam_series_cd
                         AND a.exam_yr = c.exam_yr
                         AND a.exam_lvl_cd = c.exam_lvl_cd
                         AND a.exam_series_cd = c.exam_series_cd
                         AND b.subj_cd = c.subj_cd
                         AND b.lang_med_cd = c.lang_med_cd
                         AND (    c.examining_agency_cd <> 'CAMB'
                              AND c.examining_agency_cd <> 'SPORE'
                             )) x
      WHERE NOT EXISTS (
               SELECT *
                 FROM xe_rp_ext_result y
                WHERE y.exam_yr = x.exam_yr
                  AND y.exam_lvl_cd = x.exam_lvl_cd
                  AND y.uin = x.uin
                  AND y.subj_cd = x.subj_cd)
   ORDER BY uin
   ) XX