SQL to Select a random row from a database table
Your examples were very clear and (almost) just what I need to do. In a small dataset I find that the same record as that just selected randomly can be randomly selected again. How would you modify the random query (for MS SQL Server) to NOT INCLUDE the ....