PeopleSoft Common Interview Question:

Suppose A Simple Query involving Professor, Asst Professor and to find if both can be available before and at a mentioned date?

Submitted by: Administrator

Lets say all the data resides in a table PS_TABLE_A.

Lets say AS_OF_DATE is held by a variable as_of_date.

Here goes the query:-

Select PROFESSOR, ASST_PROFFESSOR FROM PS_TABLE_A WHERE EFFDT< as_of_date OR EFFDT= as_of_date
Submitted by: Administrator