Blog Stats
  • Posts - 170
  • Articles - 4
  • Comments - 54
  • Trackbacks - 7

 

<< What type of developer are you? | Home | Implement Script Callback Framework in ASP.NET 1.x >>

Selecting random records from a table

SELECT TOP 10 * FROM tablename ORDER BY NEWID()

Where the NEWID() function returns a new Unique Identifier.

Nice tip and so simple

 

Print posted @ Monday, April 04, 2005 10:44 PM

Comments have been closed on this topic.
 

 

Copyright © Paschal L