Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 18:28:12 GMT


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


Subj:   Re: Sorting views created on various tables
 
From:   Michael Larkins

  I was able to get all the views created on various tables from DBC.Column but, not able to sort as above.  


Did you try ORDER BY 1,2,3?

If you are simply looking to not print any repeated data values then you should be using the .suppress 1,2 option within BTEQ.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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