Using SELECT to Query the Test Table - Teradata Vantage

Configuring Teradata Vantage™ After Installation

Product
Teradata Vantage
Release Number
1.1
Published
July 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
qyu1559916244734.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4014
lifecycle
previous
Product Category
Analytical Ecosystem
Software
Teradata Vantage

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.