Post reply

Random Pull

  • March 30, 2006 at 2:47 pm

    #112608

    I have a source file that has around 300000 records; I need to pull 75 random records from the file; id is the primary key. What is the easiest way to do it.

    Thanks in advance...

  • March 30, 2006 at 3:03 pm

    #629981

    SELECT TOP 75 * FROM tableName

    ORDER BY NEWID()

     

    I think this should work.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply