Log on as temporary user to query table | Teradata Vantage - 2.2 - Using SELECT to Query the Test Table - Teradata Vantage

Configuring Teradata Vantage™ After Installation

Product
Teradata Vantage
Release Number
2.2
Release Date
January 2021
Content Type
Configuration
Implementation
Publication ID
B700-4014-011K
Language
English (United States)

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.

  1. Log on as Alex using secret as the password.
  2. 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;
  3. Verify the results:
    emp_id emp_name start_date
    1001 Mary 2010-01-10
    1002 Sam 2014-07-01
  4. Log off.