nschultz Posted October 18, 2005 Share Posted October 18, 2005 I would like to run a query in Access that selects 10 random records per group from a table.I have many different customers but their flight numbers are simalar. I want to select random 10 customers per flight number. Link to comment Share on other sites More sharing options...
Guest Dedo Posted October 21, 2005 Share Posted October 21, 2005 select COLUMNS from YOUR_TABLE_NAMEwhere mod(SOME_ID_OR_NUMBER_COLUMN, to_number(substr(to_char(sysdate,'ddmmyyyyHHMISS'), 13, 2))) = 0and rownum < 11 This work in ORACLE database. You can try in Access! Link to comment Share on other sites More sharing options...
nschultz Posted October 21, 2005 Author Share Posted October 21, 2005 Thanks but, I do not see how this can be used in Access. Any other help would be great. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now