navigation
 Thursday, March 16, 2006
Select a Random Row from a Table with T-SQL

Here's a mysterious bit of code that doesn't look like it ought to work, but yet it does

select top 1 *
from table
order by newid()

posted on March 16, 2006  #    by Adam Anderson  Comments [1] Trackback
Related posts:
T-SQL: How To Obtain SCOPE_IDENTITY() From an Object With an INSTEAD OF INSERT Trigger
T-SQL: A Simple Way to Build a String from a Column
T-SQL: How to Invert a Bit
Get More Out of Your Foreign Keys
How To Write Secure Dynamic SQL
Good article about some lesser-known differences between temp tables and table variables

Copyright © 2003-2008 Falafel Software Inc.