Home Forums SQL Server 7,2000 General How to get certain number of random records RE: How to get certain number of random records

  • August 17, 2003 at 5:29 pm

    #470216

    I sometimes use NEWID() to "randomise" results. Eg.

    select top 4 * from pubs.dbo.authors

    order by newid()

    Cheers,

    - Mark


    Cheers,
    - Mark