Generate 2 Outputs From Db

I have one Table and would get 2 Outputs of this Table:

i need the output to be sorted like this

“row19″,”row12″,”row69″,”row8″,”rowXX”

second output is something similar.

Im Looking for a highly professional MSSQL DB Engineer and scripter