Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display random sample

Status
Not open for further replies.
akaka

akaka

Programmer
Joined
Dec 15, 2004
Messages
9
Location
US
Is there a was to display only a random sample of just say 100 rows from a result set of 10 milliom rows

thanks
Atul Kakade
 
Sort by date Sort by votes
what type of distribution would you want from these 100 million rows?
 
Upvote 0 Downvote
nothing particular
Functionality soemthing like teraminer random sample
 
Upvote 0 Downvote
nothing particular
Functionality something like teraminer random sample
 
Upvote 0 Downvote
check out technote TN4100-72X-0210 "How to create a report that returns a random sample of data in MicroStrategy."

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

szeiss
  • Locked
  • Question Question
Display FY2011 instead of FY-1 in Report
Replies
0
Views
378
szeiss
szeiss
jadr
  • Locked
  • Question Question
Line graph displays too much data
Replies
0
Views
198
jadr
jadr
mstrpup
  • Locked
  • Question Question
Displaying single date when metrics filtered by two diff date attr
Replies
2
Views
329
mstrpup
mstrpup
teccum
  • Locked
  • Question Question
Date Prompt Display
Replies
0
Views
144
teccum
teccum
Rambo2292468
  • Locked
  • Question Question
Attribute decimal display
Replies
1
Views
225
FLB
FLB

Part and Inventory Search

Sponsor

Back
Top