Jump to content

Random records per group


Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...