I am trying to write a query. It will take employee IDs from a table, and assign random numbers between 1-45 in whole number increments. The data is in Oracle - sql.
Got it:
round(DBMS_RANDOM.VALUE (1, 45))
round helps me get whole numbers.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With