Use the SELECT statement to query the employee test table. See Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
Use the LOCKING ROW FOR ACCESS syntax in views to prevent deadlock when there is contention accessing table data. See LOCKING Request Modifier in Teradata Vantage™ SQL Data Manipulation Language , B035-1146 .
- Log on as Alex using secret as the password.
-
Query the employee table to find the employees who were hired prior to 2015. For example:
SELECT emp_id, emp_name, start_date FROM Tables_Database.employee WHERE start_date < '2015-01-01' ORDER BY emp_id;
-
Verify the results:
emp_id emp_name start_date 1001 Mary 2010-01-10 1002 Sam 2014-07-01 - Log off.