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

  • Interview Candidate
  • 1
  • 1508

Showing Answers 1 - 1 of 1 Answers

arundgati

  • Jun 22nd, 2006
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions