Skip to Content
0
Former Member
Oct 19, 2005 at 05:46 PM

hr programming questions

41 Views

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'.