Joma Rajab

Joma Rajab

  • NA
  • 110
  • 51.7k

How make order random and distinct in sql query

Sep 1 2016 11:03 AM
I need to select random value from table and it should be distinct . I tried but I could not please help 
this the query I have used but I got error say order by item must appear in the select list if select distinct is specified 
  1. string checkentrycmd = "select distinct TOP(10) * from dbo.Quiz where MaID=" + Request.QueryString["Id"].ToString() + " ORDER BY CHECKSUM(NEWID())";  

Answers (4)