Skip to Content
author's profile photo Former Member
Former Member

hr programming questions

There are multiple versions of SELECT for HR e.g.

SELECT * FROM PA0001

WHERE PLANS = LEADING_POSITION-OBJID

AND BEGDA LE PN/BEGDA

AND ENDDA GE PN/ENDDA.

what difference between these 5 versions of SELECT?

*1. ?

  • and begda le pn/begda (begda)

  • and endda ge pn/endda. (endda)

*2. ?

  • and begda le pn/begda (begda)

  • and endda ge pn/begda. (begda)

*3. ?

  • and begda le pn/endda (endda)

  • and endda ge pn/begda. (begda)

*4. ?

  • and begda le pn/endda (endda)

  • and endda ge pn/endda. (endda)

*5. the newest record

  • AND ENDDA = '99991231'.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 06:05 PM

    Take the following records

    start date end date

    Record A 21/10/2003 28/20/2003

    Record B 29/10/2003 01/10/2005

    Record C 22/10/1999 31/12/9999

    Assuming selection criteris is 20/01/2003 to 02/10/2005

    WIth the above data lets analyse your questions .

    1. This select will select records which have begin date less than section screen begin date and end date greater than selection screen end date. So in our case record C will be selected

    2. In this case C will be selected

    3. In this case all the 2 records will be selected . This is the case which will be mostly used unless there are specific reqirements. This wil fetch all records whihc have either thier begin or end date in the given range.

    4. Only C will be picked up.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.