Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Nov 2008 @ 19:24:15 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Select statement as a column
From:   Anomy Anom

<-- Anonymously Posted: Tue, 25 Nov 2008 12:03 -->

I got the following request from a user and am not sure if this can be done. Checking if there is a way.


When working with Oracle, you are allowed to put a select statement in for a column.

     (sel count(*) from dbc.tables where tablekind='T') num_tables
     dbc.dbcinfo a

When I try stuff like that in Teradata, the SQL crashes. Is there a technique I can use to simulate a select statement as a column in Teradata? I know I can do a cross join in the from clause, but is there a way to put it into the select clause.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020