Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2004 @ 18:35:14 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Low-values
From:   uma

I have some low-values in a column and found them by using hashrow function. But how to select all the data where this column has low- values.

My select query is like this

     select hashrow(coulmn1), column1, length(column1) from dbname.tabl1
     where table_id=1

Result is like this

     HASHROW(column1)    column1          Characters(column1)
     00000000                             30

Thanks in advance,


  <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