This sample script produces a result set of random rows from a table. It does so by populating one of the columns with a random number, and then doing a select statement that uses it to sort the results.
On the right, you will find the script along with the sql statements required to create the required table. Both files are just samples, and should be appropriately modified and integrated to suit any specific development requirement. Don't forget to initialize the variables at the beginning.