Randomly select rows in SQL ServerHi,
I have around 100 questions in SQL Server. Out of these 100, I need only 20 questions randomly. That is on every click (Button Click) i need to get separate set of questions. Question repetition is allowed.
What kind of loop I can use...
Platform: C#.net windows application