A couple of times recently I've seen the question asked, 'How can I select a single row at random from a table?'. There are often a few ways of doing this suggested, most seem to rely using CTEs or temp tables. I thought I'd share, in a quick post a very simple and easy way... Continue Reading →