Dear The_Doc_Man ,
Thanks for ur reply. I have twotable with the following structure
tblrecords
1.studentid-number
2.Question_ attended-Text
and
tblquestions
1.question id-number
2.questions-Text
Now What i am doing is select a random questionid and question...
Yes I want to retrive all the 50 records in a random order.If all the 50 records are retrived then i want to retrive a null record.Is it possible ? :confused:
Dear aje,
Thanks for ur reply.It worked well. I have a ids of 1-50. I want to retrive the ids from 1-50 in random
order.If all the IDs are returned from the id column,then query should return a null values.What logic can I use.
Shall I store the previously returned...
Hi all,
I am having one table with id from 1 to 50. Now I want to return random records from that table using rnd.The point is that is there any funntion like
Select [id] from tblids where id not in (values) with rnd
Thanks in Advance
Dana