All Forums UDA
nmenon 1 post Joined 09/08
15 Sep 2008
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? ThanksNirup

Adeel Chaudhry 773 posts Joined 04/08
15 Sep 2008

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

-- If you are stuck at something .... consider it an opportunity to think anew.

MaslowB 6 posts Joined 10/08
09 Oct 2008

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

Fred 1096 posts Joined 08/04
09 Oct 2008

SELECT * FROM DBC.DBCINFO;

You must sign in to leave a comment.