Post reply

Select Random records

  • July 11, 2006 at 12:06 pm

    #115766

    Is there an easy way to select a random 15,000 from a 100,000 records.

    the only fields I want is last, first, email

     

    SELECT FIRST, LAST, upper(EMAIL) FROM ACCOUNT

    INNER JOIN MEMBERNAME ON ACCOUNT.ACCOUNTNUMBER = MEMBERNAME.ACCOUNTNUMBER

    WHERE MEMBERNAME.TYPE=0

    AND EMAIL IS NOT NULL

    AND ACCOUNT.CLOSEDATE IS  NULL

    AND ACCOUNT.ACCOUNTNUMBER IN (SELECT ACCOUNTNUMBER FROM ACCOUNTWARNCODE

          WHERE WARNCODE <> 98)

    AND DBO.FNGETAGE(BIRTHDATE, GETDATE()) >=18

     

    Thanks Peter

  • July 11, 2006 at 12:14 pm

    #648558

    SELECT TOP 15000 .....

    ORDER BY NEWID()

  • July 11, 2006 at 12:18 pm

    #648559

    Thanks, work great

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

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