Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2001 @ 13:26:10 GMT


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


Subj:   Quantile statement
 
From:   Jaswant Singh

Does anyone know whether there is a problem with running multiple quantile statements in the same SELECT

the following SQL runs (Teradata V2R4) but does encounter a deadlock error intermittently before finally resolving itself :

insert into temptable
select
customer_key
,quantile(5, total_sales_value)
,quantile(3, visits_in_store)

is the only way round this problem to have two inserts?


Thanks in advance

Jaz



     
  <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: 27 Dec 2016