SELECT is ANSI SQL:2011-compliant with extensions.
In Teradata SQL, the FROM clause is optional. This is a Teradata extension to the ANSI SQL:2011 standard, in which a FROM clause is mandatory.
The WITH, SAMPLE, QUALIFY, and TOP clauses are Teradata extensions to the ANSI SQL:2011 standard.
The documented syntax specifies the ANSI SQL:2011 ordering of these clauses: FROM, WHERE, GROUP BY, HAVING, and ORDER BY. Teradata Database does not enforce this ordering, but you should observe it when you write applications to maintain ANSI compliance.
To select data from a table, you must have the SELECT privilege on the table or column set being retrieved.
To select data through a view, you must have the SELECT privilege on that view. Also, the immediate owner of the view (that is, the database or user in which the view resides) must have SELECT WITH GRANT OPTION privileges on all tables or views referenced in the view.
If indirect references are made to a table or view, then the privileges must be held by the immediate owner of the object being accessed rather than the user executing the query.
See SQL Data Control Language and Database Administration for more information.