Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 06 Jun 2005 @ 17:31:07 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Question about SAMPLING
From:   Arun.Ballari

Hi Gurus,

I need to get a sample of x records per rep id. I know how to get a sample from the entire table set, but need to know how to do this for each of a group of ids.

     My original query is:
     select    APP_NUM,

If I add a sample statement to the bottom I get a sample of x records from the entire table. But I need a sample of x records for each REP_ID. If you have any ideas, please fill me in.

Intended result:

     Rep A Sample Record 1
     Rep A Sample Record 2
     Rep A Sample Record 3
     Rep A Sample Record 4
     Rep A Sample Record 5
     Rep B Sample Record 1
     Rep B Sample Record 2
     Rep B Sample Record 3
     Rep B Sample Record 4
     Rep B Sample Record 5
     . .


Arun K Ballari
IT- Enterprise Data Warehouse
Verizon Wireless A

  <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