I used this code but every time I once close and run it again, the sequence of questions is same(its in sequence like 1,2,3,4...). How can I change the sequence every time?
select *,rnd(ID) from Test order by rnd(ID)
Ajay_9
0
Newbie Poster
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
what is ID? what is rnd(ID)? Is that generating a random number seeded with ID? Or something else? What SQL database is this for?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.