0

I am working on a project which is an automatic Quiz Assistant. I am using SQL Server I want to get random data from database to make other options of MCQ questions. Is there any method or query to get data randomly from database?

1 Answers1

4
SELECT 
    SomeColumn 
FROM 
    SomeTable
ORDER BY 
    CHECKSUM(NEWID())

Credits go to https://stackoverflow.com/a/121634/381995

Community
  • 1
  • 1
buckley
  • 13,690
  • 3
  • 53
  • 61