Krunal's Blog

Because there’s always more to learn

Browse by Tags

All Tags » SQL (RSS)
Sorry, but there are no more tags available to filter with.
Getting random records from database table
Recently, in one project i need to get random records from sql server table and i found a good way to do same. SELECT TOP <n> <column list> FROM <table> WHERE <criteria> ORDER BY NEWID() The main function is NEWID() which return...
Posted: Sep 27 2008, 12:48 AM by krunalm | with no comments
Filed under:
More Posts