Example: Querying Employee Names - Analytics Database - Teradata Vantage

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;