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