The following query returns the names of employees who joined the company on the first day of the week:
SELECT empname from emp WHERE DAYNUMBER_OF_WEEK (date_of_join)= 1;
The following query returns the names of employees who joined the company on the first day of the week:
SELECT empname from emp WHERE DAYNUMBER_OF_WEEK (date_of_join)= 1;