Online reference to OLAP functionality in Teradata SQL

UDA
N/A

Online reference to OLAP functionality in Teradata SQL

Hi, I am looking for SQL syntax for CUBES, ROLLUPS, TOP , etc extensions by teradata to ANSI SQL. Is there an online reference? Thanks
Nirup
3 REPLIES
Teradata Employee

Re: Online reference to OLAP functionality in Teradata SQL

Hello,

Yes it surely is. Goto "http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Database", select the Teradata version, and look for "SQL Reference: Data Manipulation Statements".

HTH.

Regards,

Adeel
Enthusiast

Re: Online reference to OLAP functionality in Teradata SQL

How do I tell what version of Teradata I'm operating on?
Teradata Employee

Re: Online reference to OLAP functionality in Teradata SQL

SELECT * FROM DBC.DBCINFO;