Example: Querying Employee Names - Advanced SQL Engine - Teradata Database

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;