Hi All,
Below is my query. In that i will pass the emplid and comparison date dynamically.
For that emplid and date combination, if project id is present then i need to fetch that project id. if project id is not present then i need to display some default value.
- When query returns project id i want to exclude the default value, if query not return any row then i need to get some default value.
Note : Query may return one or more projectid for one employee.
SELECT B.PROJECT_ID FROM PS_CTSRM_ASGNSR_VW B , PS_RS_ASSGN_DETAIL C WHERE B.ASSIGNMENT_ID = C.ASSIGNMENT_ID AND
B.EMPLID = '155114'
AND B.ASSIGN_STS IN ('A','C') AND TO_DATE('2019-08-01','YYYY-MM-DD') BETWEEN C.START_DT AND C.END_DT
In below example my query returns value,so no need the default value in this case.

in below example query not return any row , so i want to display some default value.
