Welcome Guest. Sign in or Signup

1 Answers

Retrive Effective Dated Row

Asked by: 2288 views SQL

PeopleSoft provides the concept of Effective Date for recording history. Can you write an SQL that fetches the current effective dated row from a table?

Related Questions

1 Answers



  1. RajendraPrasad on Jul 25, 2012 Reply

    SELECT * FROM TABLE_NAME A
    WHERE A.EFFDT=(SELECT MAX(B.EFFDT) FROM TABLE_NAME B WHERE
    B.KEY_FIELD=A.KEY_FIELD
    B.EFF_STATUS=A..EFF_STATUS
    AND B.EFFDT<=SYSDATE)

    +5 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question