how to select random recods or rows from sql server table including row no
Posted on 2011-09-04
My sql query is below
SELECT top 24 ROW_NUMBER() OVER (ORDER BY QuestionID) AS QuestionNo, Q.QuestionID From Questions Q
ORDER BY NEWID()
The first part " top 24 ROW_NUMBER() OVER (ORDER BY QuestionID) AS QuestionNo" gives me a row no. This part "ORDER BY NEWID()" gives me random rows. The results are like below
The above query first adds row no column to the other columns and then pulls the random records whereas I want the random questions first and then added row number to them e.g.