SQL Server rotary records

3

I would like to know how to select routing records from a table. For example I have a table called disclosure and I want the records to be selected in such a way that today swallows the element x, y, z. Tomorrow, swallow y, z, x. The next day z, x, y, and so on. How to proceed?

    
asked by anonymous 15.12.2015 / 21:16

1 answer

1

You can create a column and play random values through the RAND function and sort by this column. Whenever you want to change sorting, just set new random values for this column.

    
17.12.2015 / 04:08