Generate a random number in the range 1 - 10

user_130376 0
Viewed 172685

Since my approach for a test query which I worked on in this question did not work out, I'm trying something else now. Is there a way to tell pg's random() function to get me only numbers between 1 and 10?

random postgresql sql
8 Answers

Try This:

Select (ROW_NUMBER() OVER (ORDER BY ItemDesc ASC)+15000) as ID, ItemCode, ItemDesc
user_66318640
Related