I often get asked how to generate random rows in SQL without having to create a table with required number of rows. For example, how can we easily print out the first 100 numbers without first cre…