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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random query selecting two records

Status
Not open for further replies.
tedmillerx

tedmillerx

Programmer
Jan 6, 2001
52
US
I need to write a query that randomly selects two records for each customer service rep of an order history table for one day.

In other words, if Joe and Keith each enter about 30 orders today, I want to randomly choose two orders from Keith and two orders from Joe in the same query.

How do I do it?
 
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
403
dhookom
dhookom
ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
755
jedraw
jedraw
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
348
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top