Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Apr 2004 @ 10:14:26 GMT


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


Subj:   Selecting records with Max Date
 
From:   Manish Kumar Maurya

hi ALL

i have this problem in SQL

the scenario

i have a table where there is a date col, target col and definition col

the requirment is to get the records or target for definition number 42, 44, 55 where the date is max

every definition number will have many records with diff date

so i want the records with the latest date


Thanks on advance


also can any body tell me what do use in teradata sql in place of

(select top 10 clause) from sql server


MKM



     
  <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