Home Forums SQL Server 2008 T-SQL (SS2K8) Top 1 record order by column and random RE: Top 1 record order by column and random

  • January 25, 2018 at 2:27 pm

    #1977437

    Just put IsMember at the front of the order by ðŸ˜€

    SELECT TOP 1 * FROM @T ORDER BY IsMember DESC, NEWID()