Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 05 Mar 2004 @ 20:22:56 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Crosstab SQL
From:   Victor Sokovin

  Is it possible to make a Crosstab query using a single SQL statement. The SQL statement can have multiple subqueries, but nothing more than as I only have SELECT access to tables/views. Please help.  

It's a classical question in SQL. I'm sure you'll get a lot of answers ranging between third party utilities, "SQL for Smarties" recipes and creative homegrown solutions.

If you need an easy to remember method I leave the floor to Philip:




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