I am trying to figure out how to write a SQL query which outputs 10 records at random from a table given a certan condition.
I am using this query: SELECT TOP 10 * FROM MY_TABLE WHERE DURATION>50 AND DURATION<7000 ORDER BY RAND()
My records include also dates and I can see that such 10 outputs are still in sequence (from the dates) which is not what I want.
Any idea haw I can get it? I am using SQL 2000.
Thank you for your help!!