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
- string checkentrycmd = "select distinct TOP(10) * from dbo.Quiz where MaID=" + Request.QueryString["Id"].ToString() + " ORDER BY CHECKSUM(NEWID())";