1 Reply Latest reply: Jun 9, 2009 7:25 AM by APC RSS

    Equivalent keyword in Oracle for QUALIFY of Teradata

    447396
      Hi,

      In teradata database we can write a query like below :

      select sls_doc_id, sls_dlvr_doc_id, rank() over (partition by sls_dlvr_doc_id order by sls_dlvr_doc_id) rn
      from cdp_analysis.v_sls_dlvr_doc_dtl
      QUALIFY rn > 1;

      If I want to write an equivalent thing in Oracle then I can write an equivalent like below :

      select sls_doc_id, sls_dlvr_doc_id
      from
      (
      select sls_doc_id, sls_dlvr_doc_id, rank() over (partition by sls_dlvr_doc_id order by sls_dlvr_doc_id) rn
      from cdp_analysis.v_sls_dlvr_doc_dtl
      )
      where rn > 1;

      I just want to know is any keyword exist in Oracle which is equivalent to QUALIFY of Teradata?

      Regards,
      Koushik